How to use data from external sources

  • Thread starter Thread starter rishi
  • Start date Start date
Hi,
I'm trying to create my portfolio and get the current stock price from
the web. I have a link which returns only one value.
http://finance.yahoo.com/d/quotes.csv?s=SATYAMCOM.NS&f=snl1
...
Is it possible to directly use this result in a cell?
Click to expand...

With Excel 2003, this works for me.

Select a cell.

Use
Data > Import external data > New web query
This opens a web browser window.

In the window's Address bar, enter the URL and press Enter. Then click
the "Import" button.

When I did this, the cell ended up with
SATYAMCOM.NS,"SATYAM COMPUTER S",81.05
Formulas starting with the cell can put the parts you want in other
cells.

Now save the file.

Later, you can right-click on the cell and use
Refresh data

For more features of web queries, look in Excel's built-in Help.
 
Hi,
I'm trying to create my portfolio and get the current stock price from
the web. I have a link which returns only one value.http://finance.yahoo.com/d/quotes.csv?s=SATYAMCOM.NS&f=snl1

Now I want to pass a cell reference and create a dynamic query. I can
do it using another CSV file or a macro, but i dont want to use
these.

Is it possible to directly use this result in a cell?
Click to expand...

I have a free file that allows you to type in a list of as many
symbols symbols as desired and get the latest quote Yours posted
$81.05. Properly aligned in file.

Symbol Name Basis Shares Last Trade Value Profit
IBM International Bus $10,000.00 100.00 $124.24 $12,424.00
$2,424.00
T AT&T Inc. - $26.72 $-
MSFT Microsoft Corpora $1.00 10.00 $23.73 $237.33 $236.33
BNI Burlington Northe - $100.21 $-
SATYAMCOM.NS SATYAM COMPUTER S - $81.05 $-

Ask me off list at (e-mail address removed) and I'll send to you
 
Hi,
I'm trying to create my portfolio and get the current stock price from
the web. I have a link which returns only one value.http://finance.yahoo.com/d/quotes.csv?s=SATYAMCOM.NS&f=snl1

Now I want to pass a cell reference and create a dynamic query. I can
do it using another CSV file or a macro, but i dont want to use
these.

Is it possible to directly use this result in a cell?
Click to expand...

Rishi,

How about trying something like Qmatix, an Excel add-in for stock
data ?

www.qmatix.com
 
Back
Top