Google Answers Logo
View Question
 
Q: Stock Data from Yahoo in .csv format ( No Answer,   0 Comments )
Question  
Subject: Stock Data from Yahoo in .csv format
Category: Computers > Internet
Asked by: jimboski93-ga
List Price: $20.00
Posted: 22 Apr 2005 10:34 PDT
Expires: 28 Apr 2005 14:41 PDT
Question ID: 512758
I previously had a .asp script on a webpage that pulled stock data
from yahoo.  I've noticed threads relating to this, but I can't seem
to get the answer I need.
The URL that the script used to go to was:
http://finance.yahoo.com/d/quotes.csv?s=<TICKERS SEPERATED
BYCOMMAS>&f=sl1d1t1c1ohgvj1ww&e=.csv

Without the ".csv" on the end, the page loads, but I need this in .csv
format in order to parse it.  It is also important that I get all the
variables (sl1d1t1c1ohgvj1ww).

My thought was that Yahoo has changed the URL.

Can someone find the correct URL so that I can get .csv files with this information?

Request for Question Clarification by pafalafa-ga on 22 Apr 2005 12:06 PDT
Jimboski93,

I'm not sure I see the problem here.

Once you drop the csv extension from the URL, the data will appear,
and it shows up in csv style, like this:


"IBM",74.27,"4/22/2005","2:24pm",+0.24,74.05,74.70,73.26,6796900,121.3B,"71.85
- 99.10","71.85 - 99.10"


So, I'm not quite clear on what the nature of the problem is that
you're having.  Can you elaborate a bit.


Thanks.


pafalafa-ga

Clarification of Question by jimboski93-ga on 23 Apr 2005 13:05 PDT
Sure,

the webpage I'm using is only able to display the data when it can
load a .csv file and then parse it, as opposed to opening a html page
with the data in .csv format.

For example, in a different question asked (370490), the following URL is given:
http://ichart.yahoo.com/table.csv?s=IBM&a=06&b=1&c=2004&d=06&e=1&f=2004&g=d&ignore=.csv

This URL is pulling from ichart.yahoo.com and as far as I know, does
not have the other variables I need, only Date, Open, High, Low,
Close, Volume, Adj. close.

So if it simply finding where in that URL to put the other variables,
or maybe its still finding a different URL, I don't know.

Hope this helps.

Request for Question Clarification by pafalafa-ga on 23 Apr 2005 13:24 PDT
I think your original URL will work for one symbol at a time...it
doesn't seem to allow multiple symbols, even though the non-CSV
version does it just fine.

Go figure!

Would one stock at a time work for you?


paf

Clarification of Question by jimboski93-ga on 24 Apr 2005 20:21 PDT
Hmm...the old url doesn't seem to be working for me even with only one
ticker.  When I load in a ticker, say "IBM", i still receive error
messages.

As for one stock at a time, that wouldn't work.
Answer  
There is no answer at this time.

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy