4

The following query works from console:

env 'store://datatables.org/alltableswithkeys'; select * from yahoo.finance.xchange where pair in ("USDSGD")

However, the rest query: https://query.yahooapis.com/v1/public/yql?q=env%20%27store%3A%2F%2Fdatatables.org%2Falltableswithkeys%27%3B%20select%20*%20from%20yahoo.finance.xchange%20where%20pair%20in%20(%22USDSGD%22)%20&format=json&diagnostics=true&callback=

Fails with Column Mismatch error, a few weeks back this query was returning results, any ideas as to what could have changed?

wizgot
  • 338
  • 3
  • 11
  • same problem here, the query just returns ``{"query":{"count":0,"created":"2015-08-11T08:57:56Z","lang":"en-us","results":null}}``, was still working in Aug 10, 2015 – Johnson Aug 11 '15 at 08:58
  • 1
    I am switching over to openexchangerates.org till I can figure out what is wrong here. – wizgot Aug 11 '15 at 09:53
  • I noticed the same problem. The query `select * from yahoo.finance.quotes where symbol in ('YHOO')` returns results for both json and XML using YQL console but not using YQL developer nor in a javascript I have. Both were working fine 2 days ago. – user2500880 Aug 11 '15 at 11:12
  • 2
    Best I can figure this is a problem on Yahoo's end and crops up every few months....... Much of what I see suggests YQL is not stable, production ready, or having a future. – MrYellow Aug 11 '15 at 20:52

1 Answers1

0

Same problem here.

http://query.yahooapis.com/v1/public/yql?q=select%20%2a%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22MSFT%22%29&env=store://datatables.org/alltableswithkeys&diagnostics=true&format=xml

gives a columns mismatch (see output). This url works fine from the command line, but sometimes it fails for a couple of hours from my application.

output

<url>http://www.datatables.org/yahoo/finance/yahoo.finance.quotes.xml</url><publiclyCallable>true</publiclyCallable><cache>5d1e1de680846a307c9874dc3d6878dc</cache>
<url>http://download.finance.yahoo.com/d/quotes.csv?f=aa2bb2b3b4cc1c3c4c6c8dd1d2ee1e7e8e9ghjkg1g3g4g5g6ii5j1j3j4j5j6k1k2k4k5ll1l2l3mm2m3m4m5m6m7m8nn4opp1p2p5p6qrr1r2r5r6r7ss1s7t1t7t8vv1v7ww1w4xy&s=AAPL</url>
<csv>Column mismatch: [Ask, AverageDailyVolume, Bid, AskRealtime, BidRealtime, BookValue, Change</csv>
<query>select * from csv where url=@url and columns='Ask,AverageDailyVolume,Bid,AskRealtime,BidRealtime,BookValue,Change&PercentChange,Change,Commission,Currency,ChangeRealtime,AfterHoursChangeRealtime,DividendShare,LastTradeDate,TradeDate,EarningsShare,ErrorIndicationreturnedforsymbolchangedinvalid,EPSEstimateCurrentYear,EPSEstimateNextYear,EPSEstimateNextQuarter,DaysLow,DaysHigh,YearLow,YearHigh,HoldingsGainPercent,AnnualizedGain,HoldingsGain,HoldingsGainPercentRealtime,HoldingsGainRealtime,MoreInfo,OrderBookRealtime,MarketCapitalization,MarketCapRealtime,EBITDA,ChangeFromYearLow,PercentChangeFromYearLow,LastTradeRealtimeWithTime,ChangePercentRealtime,ChangeFromYearHigh,PercebtChangeFromYearHigh,LastTradeWithTime,LastTradePriceOnly,HighLimit,LowLimit,DaysRange,DaysRangeRealtime,FiftydayMovingAverage,TwoHundreddayMovingAverage,ChangeFromTwoHundreddayMovingAverage,PercentChangeFromTwoHundreddayMovingAverage,ChangeFromFiftydayMovingAverage,PercentChangeFromFiftydayMovingAverage,Name,Notes,Open,PreviousClose,PricePaid,ChangeinPercent,PriceSales,PriceBook,ExDividendDate,PERatio,DividendPayDate,PERatioRealtime,PEGRatio,PriceEPSEstimateCurrentYear,PriceEPSEstimateNextYear,Symbol,SharesOwned,ShortRatio,LastTradeTime,TickerTrend,OneyrTargetPrice,Volume,HoldingsValue,HoldingsValueRealtime,YearRange,DaysValueChange,DaysValueChangeRealtime,StockExchange,DividendYield'</query><javascript></javascript><user-time>9</user-time><service-time>6</service-time><build-version>0.2.395</build-version></diagnostics><results></results></query>
peternees
  • 170
  • 1
  • 15