One other thing: there is a plug-in for Excel / Amibroker either in the AFL library or maybe the file section in this forum. I haven't studied it but give it a look - it might simplify your task.
d
On Sun, May 3, 2009 at 8:10 PM, James
<jamesmemphis@ yahoo.com> wrote:
I didn't consider this to be "manual" because to get the OHLC in the AA window I am going to have to write what I consider code, which is easy enough but what I was hoping for was a way Amibroker to export the data on it's own, in the same manner it imports it on it's own. My Pinnacle EOD data, for example, is completey updated, turned into Metastock format, then converted and imported into Amibroker with something like 3 clicks of my mouse. What you consider code is completely out of the question for me at this point. Thanks for the clarification.
Sent: Sunday, May 3, 2009 3:45:39 PM
Subject: Re: [amibroker] Exporting quotes
You can do it both ways.
Manually: Once you have what you want in the AA Results list click the file button and put the appropriate path/file name and click save button.
Via Code: You have a cupla choices:
A. You can write a script in _vbscript_ or Jscript to run AB, load the formula, run the formula and then export the csv file.
B. You can write a script in Excel VBA and you can do what option A does and then import it in to your Excel workbook.
d
The help file says you can use the AA window to do it "way faster". Does that mean I need to use code or can I do it manually? Can you point me in the right direction on the way to do it manually?
To: amibroker@xxxxxxxxx ps.com
Sent: Sunday, May 3, 2009 2:34:20 PM
Subject: Re: [amibroker] Exporting quotes
Do you mean via code? There is a way to do it manually.
d
On Sun, May 3, 2009 at 2:30 PM, James
<jamesmemphis@ yahoo.com> wrote:
![]()
I am trying to export intraday futures quotes into excel to make my own continuous contracts. In reference to the tools menu, the help file states:
Export to CSV file
Runs a script that exports the database to the CSV file. Note that you can use Automatic Analysis window to export the quotes way faster than with use of this script.
I do not see how to export data via the AA window. I have found 2 formulas in the library, Export EOD or Intraday to .csv file and Export Intraday Data, that were written to do this. Is this above statement referring to running one of these formulas or is there a way to directly export the data in the AA window that I am missing.
Thanks,
James