I want to display on a wordpress page the total volume of shares traded on the NYSE stock exchange the last 2 weeks that it's been open. What is the best way to go about doing this?
+2
A:
Yahoo Finance lets you export their data. For a ticker, on the left sidebar there is a link to Historical Prices. On the bottom of that page there is a link "Download To Spreadsheet".
You could pass that to fgetcsv to parse it.
Alex L
2009-11-14 00:11:21
Yeah that's probably what I'll do. Let me think about this for a minute.
pg
2009-11-14 00:32:21
A:
Scraping websites for data is generally seen as unethical, depending on your intentions and the frequency of the scrape. The bandwidth isn't free, you know. Instead, you should hopefully be able to find a data feed which has been designed to be consumed by other sites, such as yours.
Not knowing very much about your domain, I wouldn't really know what to search for, but here's some guesses:
- The NYSE website seems to offer a subscription data feed
- Look around the Yahoo Finance page here
nickf
2009-11-14 00:14:31
Not to mention that content worth scraping is generally owned by another party and republishing it may well violate another party's rights. Check the legal section of any website you consider scraping or contact the owner.
Eric J.
2009-11-14 00:25:05
I guess it's analogous to saying the score of a game after the game is over. I hadn't considered the legal/ethical issues too much. Yahoo seems to encourage the use of that kind of thing with their pipes.
pg
2009-11-14 00:34:27
+1
A:
Yahoo would be your best bet as they have an unofficial api documented here:
http://www.gummy-stuff.org/Yahoo-data.htm
Tons of apps/widgets rely on this so I can't see it going away
From first glance, this url would give you what you need: http://finance.yahoo.com/d/quotes.csv?s=^NYA&f=v
Ravi
2009-11-14 00:15:08
actually I can't see a format argument for giving you volume so @Alex L's answer is probably better
Ravi
2009-11-14 00:23:04