|
PureBytes Links
Trading Reference Links
|
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 amibroker@xxxxxxxxxxxxxxx, "bruce1r" <brucer@xxx> 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 amibroker@xxxxxxxxxxxxxxx, "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/
(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/
|