stock quotes at Kaboodle::
Here's a neat way to download stock data from Yahoo, perhaps into a spreadsheet (so you can play with the data): http://finance.yahoo.com/d/quotes.csv?s= a
http://www.kaboodle.com/ybenisrael/stock-quotes.htmlHOME |
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=&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?
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 Daily Dose of Excel » Blog Archive » Updating Stock Quotes::
Apr 1, 2008 The OP has an external query pulling stock quotes from Yahoo! . and pull the data as often as you like without the .csv conversion.
http://www.dailydoseofexcel.com/archives/2008/04/01/updating-stock-quotes/HOME |
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
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. StockLiveUsers : STOCK LIVE- Indian Stock Market Software::
>-Intraday Data in CSV format >-Future Contracts Data ** STOCK TICKER BAR Answers, a new Yahoo! community, is a question and answer exchange where the
http://finance.dir.groups.yahoo.com/group/StockLiveUsers/?tab=sHOME |
<?php // $Id$ /** * @file * A wrapper API for the retreiving stock ::
Implement a HTTP request to Yahoo Finance to retrieve stock quotes. Symbols are returned in CSV format. return _stockapi_parse_csv($results->data);
http://cvs.drupal.org/viewcvs/drupal/contributions/modules/stockapi/stockapi.inc?rev=1.1HOME |
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.
 Where's The Advantage In Windows Genuine Advantage?
 Stocks Bounce After S&P Joins Bear Market
|
HOME