[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: Exporting quotes



PureBytes Links

Trading Reference Links

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 amibroker@xxxxxxxxxxxxxxx, James <jamesmemphis@xxx> 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 <waledingo@xxx>
> To: amibroker@xxxxxxxxxxxxxxx
> 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 <waledingo@xxxxxx com>
> 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 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
>




------------------------------------

**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to 
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/