Yahoo Query Language Problem
- by Damiano
Hello everybody!
Today, I've started with Yahoo Query Language. I would use it to retrive stocks details, so I'm talking about Yahoo Finance.
I think there is a bug on this language.
This is my query:
select * from yahoo.finance.quoteslist
where symbol='@^GSPC'
I ALWAYS get 51 results!
it's impossible, take a look at: http://it.finance.yahoo.com/q/cp?s=^GSPC
There are 500 results!
I also tried some paging parameters.
select * from
yahoo.finance.quoteslist(50,30) where
symbol='@^GSPC' (to get from 50 to 80)
select * from
yahoo.finance.quoteslist(100) where
symbol='@^GSPC' (to get the first 100
results)
select * from yahoo.finance.quoteslist
where symbol='@^GSPC' limit 30 offset
50
but ALWAYS the last stock is:
<quote symbol="BBY">
<Symbol>BBY</Symbol>
<LastTradePriceOnly>41.03</LastTradePriceOnly>
<LastTradeDate>5/7/2010</LastTradeDate>
<LastTradeTime>4:00pm</LastTradeTime>
<Change>-0.48</Change>
<Open>41.35</Open>
<DaysHigh>42.35</DaysHigh>
<DaysLow>39.60</DaysLow>
<Volume>14129531</Volume>
</quote>
Why do I have this kind of problem?
Thank you so much for your support!
(P.S. I've tested it on Yahoo YQL console)
