How to get key statistics for yahoo finance web search api?

Question

I am working on retrieving yahoo finance companies data and I was succeeded in getting the companies stock data. Apart from the basic data I am also trying to retrieve key statistics data for the same company. Below image is the key statistics fields which I require.

I am using yahoo web service api to get the stock data. But when I am trying to add the parameters like f=nab and f=snbaopl1 , I am getting 406 error response code. The below is the finance api which I am using.

http://finance.yahoo.com/webservice/v1/symbols/SPARC.BO/quote?format=json&view=detail&f=nab

If that is the way to give then how should I get the stocks key statistics for companies.

Can anyone help me out ? I am trying very hardly and researching in many ways but I didn't found any alternate options. The one which I found were deprecated. Why no one is responding to the yahoo questions — bunny sunny, Jul 28 '16 at 05:27

score 17 · Answer 1 · answered Aug 07 '16 at 10:48

17

You can try access this link:

https://query2.finance.yahoo.com/v10/finance/quoteSummary/YOUR_COMPANY_SYMBOL?modules=ANY_PERMITTED_MODULE_SEPPARATED_BY_COMMAS

i found some modules that i think are interesting:

assetProfile
financialData
defaultKeyStatistics
calendarEvents
incomeStatementHistory
cashflowStatementHistory
balanceSheetHistory

this link will response with a json file.

answered Aug 07 '16 at 10:48

Yago Rodriguez

354
1
10

Can this be altered to retrieve a csv file? – Shane Goodman Aug 27 '16 at 07:01
1

Thankyou!! Thats what I was looking for... but there are still couple of attributes that I couldn't get which I needed i.e. Price/Sales (ttm), Market Cap (intraday) [very important], Price/Sales (ttm) Any help regarding these attributes? – Syed Ehtsham Abbas Nov 01 '16 at 12:25
Try with summaryProfile – Yago Rodriguez Nov 01 '16 at 14:37
1

@YagoRodriguez Is there any documentation on this API ? I was trying to get an idea of the query parameters. – nitimalh Feb 17 '17 at 16:29
just try the parameters and read what they return... is what i did – Yago Rodriguez Feb 18 '17 at 18:18
1

@YagoRodriguez This is great. I have to ask though - if there're no docs on it, how did you come up with it? I've been busting my head trying to scrape from the new HTML page with no luck and this really saves the day. – Tom Granot Mar 20 '17 at 10:52
I'm thinking this won't be available for very long...a year at most maybe. – wordsforthewise Nov 08 '17 at 02:47
Is it possible to get information on the major holders? – tommy.carstensen Jan 11 '18 at 01:14
Great list. Also recommendationTrend is a useful module – Dr Xorile Mar 04 '18 at 01:06
@YagoRodriguez how did you identify these modules – Maclean Pinto Jun 09 '21 at 17:13

score 2 · Answer 2 · answered Aug 09 '16 at 05:01

2

I have succeeded in getting yahoo finance key_statistics data by using the following quotes api http://finance.yahoo.com/d/quotes.csv?s=MSFT&f=snd1l1ydrbj1mt8opjk

By default the api will display the output in csv format if we want we can also convert the CSV output to JSON format.The quotes api is working perfectly fine to my requirement in getting the above mentioned statistics which are given as f=snd1l1ydrbj1mt8opjk and also getting the JOSN format by converting the csv output to JSON.

answered Aug 09 '16 at 05:01

bunny sunny

301
6
15

Still works as of the 20th of March, 2017. Also, great catch! – Tom Granot Mar 20 '17 at 10:53
What is meant by `f=snd1l1ydrbj1mt8opjk` ? Can you explain what this fields indicate? Thanks. – Shuwn Yuan Tee Aug 15 '17 at 04:21
1

s = symbol (i.e., Ticker symbol) n = company full name d1 = Last Trade Date l1 = Last Trade (Price Only) y = Dividend Yield d = Dividend / Share r = P/E Ratio b = Bid j1 = Market Capitalization m = Day’s Range t8 = 1yr Target Price o = Open p = Previous Close j = 52-Week Low k = 52-Week High – bunny sunny Aug 18 '17 at 11:41
1

No longer works, now it's saying "It has come to our attention that this service is being used in violation of the Yahoo Terms of Service. As such, the service is being discontinued. For all future markets and equities data research, please refer to finance.yahoo.com." – wordsforthewise Nov 08 '17 at 01:45

How to get key statistics for yahoo finance web search api?

2 Answers2