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

Re: [amibroker] Re: How to import XYZ csv data into AB 3D optimization graph?



PureBytes Links

Trading Reference Links

You must consult the Help->About in the 3D Viewer for usage terms.
3D viewer is provided as an integral part of AmiBroker and 
it is prohibited to run it stand-alone to display non-AmiBroker generated files.

Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message ----- 
From: "bruce1r" <brucer@xxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Friday, May 15, 2009 3:34 PM
Subject: [amibroker] Re: How to import XYZ csv data into AB 3D optimization graph?


> Ozzy -
> 
> I was here to make another post, but can hopefully offer some quick help
> with an old existing AFL that I had.  You defined the goal as plotting
> an existing CSV file through AB's 3D graphing program O3G.EXE.
> 
> A little background - O3G processes CSV files with a header line
> representing labels,  and then data points with each line in the order
> Z,X,Y.  If your data is in that format, you can just run O3G.  For
> example, here's an example of a first few lines -
> 
> Equity,Period1,Period2
> 83039,5,20
> 146415,5,40
> 150276,5,60
> 
> I did the following AFL as a simple, teaching example for a talk about
> two years ago.  It was intended to show how to generate 2-D ribbon and
> 3-D surface plots with data manipulation in AFL, and to call an external
> program - all wrapped up in one AFL.  So, it generates data internally
> and then calls a routine called Plot3D to write it out to a CSV file,
> run O3G, and return.  If you  have an existing file, it should just be a
> matter of reading it into appropriate variables and calling the routine.
> You might find the info in the header comments useful, also.  You can
> run it as a Scan, Explore, or Indicator.
> 
> The AFL was a little too long to post, look for the file, Plot3D.afl, 
> in the Files section.
> 
> -- BruceR
> 
> P.S. O3G can be useful for visualizing certain things, but manipulation
> of Excel plots from AB opens up some more interesting possibilities. 
> Another story for another day.
> 
> --- In amibroker@xxxxxxxxxxxxxxx, "ozzyapeman" <zoopfree@xxx> wrote:
>>
>> Hello, wondering if anyone has done this before - If I have a csv data
> file containing three data columns, is there a way to import this into
> the AA so I can use AB's 3D graphing utility to see the 3D plot?
>>
>> It seems that AB can only import it's own specific HTML format, not
> plain old CSV.
>>
>> So then an alternate question is - can a CSV file, as previously
> described, be easily converted into AB's required HTML format, either
> with a utility or via some kind of scripting? Can anyone point me to a
> basic methodology? The only scripting language I have a basic handle on
> is VBscript. Hoping this is not too complex.
>>
> 
> 
> 
> 
> ------------------------------------
> 
> **** 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
> 
> 
> 


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

**** 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/