I am using Amibroker with a 1-minute database. I am also using XLQ for Excel.

I noticed that for _any_ ticker the volume info shown on Amibroker's daily chart will be _less_ than the volume retrieved via XLQ (which again connects to IQFeed). The difference is in the 10-15% range, for all days, all tickers. I have cross-checked the information with Yahoo EOD data and the data in Excel/XLQ matches (to the 100, which is fine).

See attached screenshots for AAPL (created 3 days ago) - Excel.png and Yahoo.png.
However, if I look on the Amibroker chart I get the following values, starting from 3 Feb to 21 Jan:
48,527,572
58,504,896
76,975,896
78,355,120
136,403,232
89,923,048
50,280,040
43,102,976
47,692,804
45,262,800

I contacted Amibroker's support who sent me their snapshot created using an end-of-day database (Amibroker-EOD_Setup.png) and gave the following explanation:
"Indeed – 1-minute database is recommended, however in this case the daily prices and volumes are constructed out of individual 1-minute bars captured from the stream. So – the output will depend on your intraday settings in File -> Database Settings -> Intraday Settings.

This article explains the topic in details:
http://www.amibroker.com/kb/2006/03/19/how-does-the-daily-time-compression-work/

Note however that daily values obtained from the data-stream may differ from the ‘official’ prices provided by the exchange."

How is this difference possible? Surely, the sum of volume bars should give out the daily volume? There seem to be constant 10-15% difference which can mislead the chart eye AND the exploration scripts.

As there is an option to plot data from a 'Foreign' stock, was it possible to access the EOD data using a different symbol? (e.g. made up: "AAPL.EOD"). This way I could rely on the EOD data from this ticker and continue using the 5-min chart with live prices.

Thank you.

Hello Wilkinson, within IQFeed the Intraday data only shows volume for Qualified last trades and Extended Trades, but does not include Other trade types like the End-of-Day values will. So the End-of-Day volume will always be higher than what the Intraday totals will be. As to viewing the End-of-Day volume totals within AmiBroker you will need to set the Database interval to End-of-Day for AB to pull that data. Within XLQ if you are using =xlqhVolume("Symbol", "Date Ref", "Source") this pulls the End-of-Day Volume Totals.

---

Curtis Thompson
support@iqfeed.net
support@dtniq.com
support@prophetx.com
Trading Markets Customer Service
1-800-397-7000

Thank you Curtis.

As a workaround, is there an option to retrieved the EOD data even when the feed is to set 1 minute? (with a 'special' ticker name like 'AAPL.EOD' as I asked above?).

Amibroker DB is currently set to a mixed database on 1 minute bars, therefore it constructs the daily data from the minute bars on for the daily chart. The suggested solution (storing the data in an EOD database) would defeat the purpose of working with an exploration on an intraday 5-min chart AND past "completed" EOD data.

There is a way to get a 'foreign' stock from the same database in Amibroker but can't query another (Amibroker) database (i.e would have a 1-min and an EOD DB setup).

Alternatively I was thinking about importing the EOD data to using StaticVarSet for my watch list on a daily basis, but this sounds very painful and feels an unnecessary burden... I can get today's 'full' volume data so far using GetRTData("TotalVolume").

Wilkinson
We do not have unique tickers for the data/time ranges. You can use the software to request the different time ranges.