I found a crippling bug with QLink's data retrieval.
With certain symbols, on some intraday intervals, QLink will download some but not all of the requested bars.
If I request GOOG, GS, GM, or other well-known stock, QLink fills the Excel sheet will all the bars as expected.
But if I request intraday bars of an ARCX symbol (e.g. SPY or FXP), I get this the results in the image below. QLink fails to get the first few bars, but it does correctly get the later bars. The missing data does not update no matter how long you wait.
What's strange is that this behavior is not easy to reproduce. Requesting 400 bars works, 10 works, but 100 does not. On other symbols, 400 does not work but 100 does.
It seems to work more reliably when I request a huge number of bars (e.g. 1000), so this might be a possible work around.
With certain symbols, on some intraday intervals, QLink will download some but not all of the requested bars.
If I request GOOG, GS, GM, or other well-known stock, QLink fills the Excel sheet will all the bars as expected.
But if I request intraday bars of an ARCX symbol (e.g. SPY or FXP), I get this the results in the image below. QLink fails to get the first few bars, but it does correctly get the later bars. The missing data does not update no matter how long you wait.
What's strange is that this behavior is not easy to reproduce. Requesting 400 bars works, 10 works, but 100 does not. On other symbols, 400 does not work but 100 does.
It seems to work more reliably when I request a huge number of bars (e.g. 1000), so this might be a possible work around.
Comment