Stock Quote API returning commas in data items

Hi,

I've spoken to the finance team to find out about this issue. I'll let you know as soon as I hear back from them.

Thanks,

Tom
Yahoo! Developer Network

Hi,

We don't official support this feed. The only officially supported feeds are listed on the YDN Finance page. This page also has a link to the terms of service for the official feeds.

If you need help parsing CSV there are libraries that are created to deal with it, I'm told that the commas in any of our feeds are delimited so you should be able to use that to break up your CSV into values. E.g. \, is a comma which is content , is a value separator.

Tom
Yahoo! Developer Network

Tom,

Apologies for responding so late. Actually I was on vacations so was not able to check the post.

Thanks a lot for your 2 replies.

What I am getting from your reply is that the

1. Using the aforementioned Stock Quote API is not the recommend way to get latest stock prices and instead one should use feeds from YDN Finance. Am I right in deducing this?

2. If I am not bothering you then could you please let me know which feed is officially supported that can provide detailed stock information for stock symbol(s). The reason why I am asking this to you is because I visited http://finance.yahoo.com/rssindex but was not able to figure out which feed is suitable for my purpose.

Thanks in advance.

Ishwar Jindal

I am also interested in programmatically obtaining stock data for personal use.

Are we not supposed to use http://download.finance.yahoo.com/d/quotes.csv or http://ichart.finance.yahoo.com/table.csv? If not, is there an alternative?

The only "official" feed we have is on http://developer.yahoo.com/finance/

This feed is subject to our TOS for Yahoo! APIs (http://info.yahoo.com/guidelines/us/yahoo/ydn/ydn-3955.html).

I hope that helps,

Tom

You should take this feed away! It isn't obvious that the feed handles three fields incorrectly - AskSize (a5), Bidsize (d6) and Float (f6) until time is wasted. All of these fields contain commas in the actual content whereas Average Daily Volume (a2) does not have the commas - this is a BUG period. I handled by pulling those 3 fields independently and individually.

There are several other inconsistencies with the feed that ultimately made it unusable, this is the case with almost all Yahoo feeds - including the weather feed. Wait, I know - they aren't supported :)Don't bother responding - I won't be back to read.

As a paying subscriber to the premium real time quotes, how can I can access to that data from within my own personal stock managing application? The CSV and RSS methods don't seem to care about authentication.

Also, please ignore the person that posted above me. He obviously doesn't know what if and case statements are for.

I have to agree on teh fact that removing these commas from the field a5 and b6 (or change the delimiter to a semicolumn?) will take few minutes. I understand that this is not a supported feed or whatever, but still, it is a shame that such great service has not a minimal of maintenance

Hi all,

I'm glad other people are using his own personal app. to get stock quotes. I build a little .NET program to get my - few! - quotes.
I'm looking in this topic to find information about an alternative to the CVS file. It seems there isn't a webservice for this pourpose.

Hope some dev's staff at Yahoo is reading this.

It would be nice having a Yahoo webservice to get quotes, with the 15/20 minutes delay and the account Yahoo key.

About the comma separeted values, the string I get it uses semi column.

Here you can try the link, it gets Yahoo data:
http://it.old.finance.yahoo.com/d/quotes.c...wern&e=.csv

This is the result:
YHOO;15,74;22:00;26/06/2009;+0,21;15,57;15,80;15,48;26456759;N/A;15,53;+1,35%;15,57;N/A;0,01;0,01;Yahoo! Inc.

Hope it helps

Matteo

Unfortunately, it's one of those webservices that's released as-is and doesn't have any Yahoos supporting it officially. I'll leave the thread open on the off-chance that a Yahoo! developer has been playing around with this on his own and has some ideas for you. Wish I could help but I've never worked with the Finance stuff. Sorry!

Robyn Tippins
Community Manager, YDN

Robyn,

I would like to use the stock quote data returned by http://download.finance.yahoo.com/d/quotes.csv and http://ichart.finance.yahoo.com/table.csv in a Windows sidebar gadget that I am developing for personal use. Is this personal usage permitted?

There are several non-commercial Windows sidebar gadgets (published on the internet) that make use of the stock quote data returned by these URL's. Is this type of non-commercial usage permitted?

David Wilson

Tom,

I would like to use the stock quote data returned by http://download.finance.yahoo.com/d/quotes.csv and http://ichart.finance.yahoo.com/table.csv in a Windows sidebar gadget that I am developing for personal use. Is this personal usage permitted?

There are several non-commercial Windows sidebar gadgets (published on the internet) that make use of the stock quote data returned by these URL's. Is this type of non-commercial usage permitted?

David Wilson

There's no problem with your downloading the data, assuming you stay below rate limits, you just can't redistribute it.

Robyn Tippins
Community Manager, YDN

Robyn, thanks for your quick reply.

Just want clarification of your redistribution point. If I publish a Windows sidebar gadget on the internet, which other people could download and install on their PC's, and which they could then use to download the data for their personal use -- does that count as redistribution?

David Wilson

David,

Anything that involves redistribution of the data wouldn't be in compliance. Thanks,

Robyn Tippins
Community Manager, YDN

How do I know what flag to put in?
And how can I get option quote?

Thanks

Hi all,

It is nice n easy to get a csv file full of whatever quotes I need using the following format;

http://finance.yahoo.com/d/quotes.csv?s=+t...mp;f=sot1d1hgvw

BUT is there a way to get a quote for an ISIN?????

For example, I have a stock "Invesco Perpetual Income Acc" which has a MexCode of "PPINCA" and if I try this in the above, it returns "N/A" for all the fields...!

Is there a way I can try this with the ISIN which is "GB0033031260"????

Any thoughts anyone?

Cheers

case(&quot;&quot;) <br><br>testing to see why I cant insert script. It is FAR less than 3000 words, but fails to be posted...

Hi,

I want to create a paid app using yahoo finance API(stock data) for android. Can any body help me  how to get Licence from yahoo to use that. And also documentation of API.

My mail iD plutothelastpalnet@gmail.com  and vivek1908@yahoo.com

Thanks
Vviek

Hi, 

Does anybody know what the special tag is for the .csv for 'Return on Equity' and 'Beta'? Or a way that I could get these values to a .csv (keeping in mind that I am by no means a programmer and don't aspire to be one in the near future).

Cheers

@vivek  We do not have a commercial license for the Finance feed.  Anything that involves redistribution of the data wouldn't be in compliance.

Hello -
Is there a way to get "Growth estimates" - (this year, next year, next five years - shown at  http://finance.yahoo.com/q/ae?s=IBM+Analyst+Estimates) using  http://finance.yahoo.com/d/quotes.csv  API?

Thanks

Did you ever figure out how to get Beta?

Hi,

Is there any option to get realtime data from yahoo without delay or little delay(1m)?

I am using the following,

http://download.finance.yahoo.com/d/quotes.csv?s=".$ticker."&f=sohgpl1c1p2d1t1k3&e=.csv

Thanks,
Rajib

@duzins

Robyn, you mentioned that there is no commercial license for the CSV finance feed. Would a commercial program for personal usage (i.e. without any redistribution) comply with the YDN guidelines? I'm thinking about developing a small application that displays stock quotes for personal portfolios.

Many thanks, Dirk

Is there a reason why we get these comma values? Sometimes, when the number is an integer lets say 123, I get it in 1 field but when it is 123,45 I get a field with 123 and another one with 45. I understand that it is not supported but please tell me why it is happening.

Is there a reason why we get these comma values? Sometimes, when the number is an integer lets say 123, I get it in 1 field but when it is 123,45 I get a field with 123 and another one with 45. I understand that it is not supported but please tell me why it is happening.

Comment for rajib post of Oct 12, 2012:

Don't know how to do this on Yahoo, but MarketWatch gives you real time data for one stock at a time in the form of a graph. It even includes pre- and after-hours trading.

An example URL would be: http://www.marketwatch.com/investing/stock/ge

where in this case, "ge" is the stock symbol.

I often keep two or three browser windows with different stock open on a 2nd monitor, and the graphs update in real time.

Note that you can use "djia" or "indu" to get the Dow Joones Industrial Average real time.

Hope this helps.