Hello James, The two AFL codes you mentioned in your initial posts can export data to CSV files in two-three clicks. Or if you use OLE you can do it without a single click. Yes, you seem to be aware that CSV files can be opened in Excel.
You are welcome, if you need any further clarifications. With Regards Sanjiv Bansal --- In [email protected], James <jamesmemp...@...> 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. > > > > > > ________________________________ > From: dingo <waledi...@...> > To: [email protected] > 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 > > On Sun, May 3, 2009 at 4:24 PM, James <jamesmemphis@ yahoo.com> wrote: > > > > > 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? > > > > > ________________________________ > From: dingo <waledi...@gmail. com> > To: amibro...@yahoogrou 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 Analysiswindow 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 >
