|
PureBytes Links
Trading Reference Links
|
Hello,
The Help->About window of 3D viewer says:
"IMPORTANT NOTE: This is NOT free software, It is integral part of AmiBroker - technical analysis software
packgage and may be used ONLY in conjunction with AmiBroker. Other uses without written permission
from AmiBroker.com are strictly prohibited".
It means that 3D viewer may only be used together with AmiBroker and only on AmiBroker-generated files
(i.e. optimization results).
Any other use is illegal.
Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message -----
From: "ozzyapeman" <zoopfree@xxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Friday, May 15, 2009 6:06 PM
Subject: [amibroker] Re: How to import XYZ csv data into AB 3D optimization graph?
> 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
>
>
>
------------------------------------
**** 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/
|