Accessing quotation database via OLE, previously was: How to find the size of an array

AFL Programming
#1

Moderator comment: @Zargo hijacked old thread (How to find the size of an array) for the whole different subject. It took time for original poster to clarify what he really wants. So you can scroll down to post 3 as earlier posts are "lost in the dark"

And what about the case where my Array is a foreign symbol?

BarcountLocal = BarCount;
_TRACE("BarcountLocal = " + BarcountLocal );
NewContract = ParamStr("New Ticker Symbol","TICKER");
SetForeign(NewContract);
BarcountForeign = BarCount;
_TRACE("BarcountForeign = " + BarcountForeign );
RestorePriceArrays();
How to find the size of an array
#3

That is precisely my point. I have a use case where I need to know the #bars (Array length) in a foreign symbol. This cannot be done with Barcount as SetForeign simply replaces current array values.

My use case attempts to create a continuous futures instrument from a set of futures symbols.

#4

Generally, Data Vendors provide continuous Future contracts if you subscribe to live data-feed. Otherwise, you could manually merge CSVs of different Future Expiries as received from your data-source into one CSV, then import that to form a Continuous Futures symbol instead of trying to achieve it programmatically.

#5

That is a whole different story.

What you are asking for is not AFL array access. It is direct DATABASE access.

You can access database (including ALL quotes regardless of what symbol it is) using OLE interface http://www.amibroker.com/guide/objects.html
OLE interface allows to add/remove/modify quotation data directly in the database.

This old newsletter article: http://www.amibroker.com/newsletter/05-2000.html shows precisely how to manipulate quotations directly in the database using OLE.