Geek Answers Handbook

YQL receives stock quotes by country

I have been looking for this for the past few days. I managed to get basic things through YQL, such as their stocks, prices and all.

Like this:

Select a name, symbol, LastTradePriceOnly, LastTradeDate, LastTradeTime, Change, ChangeInPercentage, PreviousClose, Open, Bid, Ask, DaysRange, YearRange, Volume, Average, MarketCapitalization, PERatio, EPSEstimateCurrentYear, TralingAnnualDividendYield = aahl.fr

But I do not know how to get stock quotes in the country. First of all, I did not receive YQL to get stock-related countries.

For example: Select Name, Symbol from yahoo.finance.quotes where Country = "India".

Thank you for your time.

+4
source share
4 answers

Using YQL in this way, you basically review the results for the given stock symbol that you provide. (Behind the scenes, this YQL table queries the data source that Yahoo Finance uses.) This is not a general-purpose database where you can make queries, such as getting a list of symbols or markets for a given country.

YQL really works for some stocks in the international market, but again you need to know the symbol. For instance:

select * from yahoo.finance.quotes where symbol="arm.l"

select * from yahoo.finance.quotes where symbol="kfa.bo"

+2
source

I am looking for the same thing, I would think that you would need to use the name of the market instead of the name of the country. those. NASDAQ, FTSE or BSE.

+1
source

API API API does not seem to work for internal accounts. Try the following:

select * from yahoo.finance.quotes where symbol = "ril.bo"

The request works and does not return any data. This is the sample I received:

 "Name": "RIL.BO", "Notes": null, "Open": null, "PreviousClose": null, "PricePaid": null, "ChangeinPercent": null, "PriceSales": null, "PriceBook": null, "ExDividendDate": null, "PERatio": null, "DividendPayDate": null, "PERatioRealtime": null, "PEGRatio": null, "PriceEPSEstimateCurrentYear": null, "PriceEPSEstimateNextYear": null, "Symbol": "RIL.BO",

YQL gives the key to the fact that it is not configured for internal exchanges. Sent in JSON - this is the message:

 "ErrorIndicationreturnedforsymbolchangedinvalid": "No such ticker symbol. <a href=/l>Try Symbol Lookup</a> (Look up: <a href=/l?s=RIL.BO>RIL.BO</a>)",

Please note that the characters I used are valid from Yahoo! own search.

Everything works great for US exchanges. Try replacing GOOG or YHOO with RIL.BO. It works like a charm.

+1
source

There is a list of important stock exchange codes for the World wise region - http://finance.yahoo.com/intlindices?e=asia , and I explained the logic of URLs and requests here - http://prasanta-paul.blogspot.kr/2013/ 01 / accessing-yahoo-finance-api.html

Hope this helps!

0
source

More articles:


All Articles