Guys, thanks very much for the pointers and AFLs! I will start playing around with this. It gives me some new options to try.
I also was not aware that I could just run the graphing exe separately. On a somewhat related note, I have another general question, which I am sure others out there have grappled with, or will at some point: Is AFL suitable to parsing through, summing up, and manipulating larger CSV files (say 60,000 rows by a dozen columns) or should I be looking for a scripting programmer off of Elance to automate Excel for this purpose? Basically, I am dumping a bunch of different optimizations and backtests to a CSV log file. I want to go through the file, sum up certain rows, count the frequency of certain variables, and generate a few statistics. My AFL skills are probably just good enough to be able to build something to do that. But I don't want to spend time building it, only to ultimately find out that Amibroker either crashes, or that AFL is too slow for the task. I imagine it will require keeping track of a few hundred static variables. So is the best route: AFL? VBscript with Excel? MYSQL? Something else? Thanks. --- In [email protected], "bruce1r" <bru...@...> wrote: > > 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], "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. > > >
