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

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



PureBytes Links

Trading Reference Links

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

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