Hi, When I saw the elaborated answers of Mike and bruce1r, my face blushed for considering my solution.
The wised and attentive reader can only understand that the exe must be used in AB world. I made many AB 3D tests and I renamed each optimize.csv to keep a trace. Then I found an easy way to load many historical results one after one to make a summary. The life of an exe file, of course, is to be executed. I apologize, TJ, for my solution that seems to be on the fringe. Best regards Tomasz Janeczko a écrit : > > > > That's OK. As long as you run it in together with AmiBroker you are fine. > > Best regards, > Tomasz Janeczko > amibroker.com > ----- Original Message ----- > From: "ozzyapeman" <[email protected] <mailto:zoopfree%40hotmail.com>> > To: <[email protected] <mailto:amibroker%40yahoogroups.com>> > Sent: Friday, May 15, 2009 10:38 PM > Subject: [amibroker] Re: How to import XYZ csv data into AB 3D > optimization graph? > > > Understood. Just wanted to point out that my files are in fact > generated by Amibroker. As mentioned, they are a compilation of > > various optimizations and backtests which I then sort. After that, I > want to re-import the file back into Amibroker to view 3D > > graphs of the opt parameters. > > > > > > --- In [email protected] > <mailto:amibroker%40yahoogroups.com>, "Tomasz Janeczko" <gro...@...> wrote: > >> > >> 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" <bru...@...> > >> To: <[email protected] <mailto:amibroker%40yahoogroups.com>> > >> 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 [email protected] > <mailto:amibroker%40yahoogroups.com>, "ozzyapeman" <zoopfree@> 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/ > <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/ <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/ <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/ <http://www.amibroker.com/devlog/> > > > > Yahoo! Groups Links > > > > > > > >
