Ha ha. That sure beats trying to do it directly inside the AA window. Oh well, I learned a few things :)
Mike --- 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. > > >
