[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] JAVA SCRIPT SIMPLE QUESTIONS


  • Date: Mon, 23 Nov 2009 09:45:43 +1030
  • From: Brenton Hill <bphill0105@xxxxxxxxxxxx>
  • Subject: Re: [amibroker] JAVA SCRIPT SIMPLE QUESTIONS

PureBytes Links

Trading Reference Links



Hi Bistrader

If you're using AutoIT anyway, you can skip using _javascript_ altogether and just control Amibroker direct from AutoIT.

In AutoIT use:

$AB = ObjCreate("broker.application")
$AA = $AB.Analysis
$AB.LoadDatabase("C:\\Amibroker\\FastTrack")

etc

Not sure about your Question 2, sorry.

If by ques 3, you mean you want to explore 10 different watchlists (eg WL numbers 1 to 10) and export 10 csv files, then just put set filter, explore and export in a loop

$Export_Directory = "C:\\Amibroker\\Temp\\"; // Location where Exported data will be saved
$ExportFileName = "MyCsvFile"; // Name of export file
$ExportFile = Export_Directory + ExportFileName; // Name of above export file with its path included

    For $i = 1 To 10
        $AA.Filter( 0, "watchlist" ) = $i
        $AA.Explore()
        $AA.Export($ExportFile&$i&".csv")
    Next

Brenton

bistrader wrote:
 

I created the following _javascript_ to do an exploration on an afl and then export the exploration to a file. I have a few questions.

1. From a structure perspective, is there anything that I should include or exclude as I try to pick up _javascript_.
2. I can not figure out how to load a reference symbol like "RUT-I" with is the R2000 so that AmiBroker knows the valid market days.
3. How to change the following if I want to loop through 10 csv files rather than just the watchlist 9 used in the following? That is, do this 10 times automatically but on csv files named In1.csv to In10.csv, if you will.

By the way, I am going through a learning process to expand my knowledge on what to do in afl, what to do in _javascript_ and what to do in AutoIt. This is part of that process.

// Build_JavaScript.js

// This _javascript_ file should:
// 1. Load a Database
// 2. Run an exploration on an afl.
// 3. Export the exploration to a csv file.

// ----------------------------------------------------------
// Create AmiBroker object and get Analysis object
// ----------------------------------------------------------
var AB, AA, i;

AB = new ActiveXObject("Broker.Application");
AA = AB.Analysis;

// ----------------------------------------------------------
// Load Database
// ----------------------------------------------------------
AB.LoadDatabase("C:\\Amibroker\\FastTrack");

// ----------------------------------------------------------
// Automatic Analysis Input and Export Information
// ----------------------------------------------------------
AFL_Directory = "C:\\Amibroker\\AFL\\"; // Location of AFL
AFL_ExploreFileName = "0_DataExport.afl"; // AFL program to get the data to be exported
AFL_ExploreFile = AFL_Directory + AFL_ExploreFileName; // Name of the above program with it's path included

Export_Directory = "C:\\Amibroker\\Temp\\"; // Location where Exported data will be saved
ExportFileName = "MyCsvFile.csv"; // Name of export file
ExportFile = Export_Directory + ExportFileName; // Name of above export file with its path included

// ----------------------------------------------------------
// Setup Exploration using info defined above
// ----------------------------------------------------------
AA.LoadFormula( AFL_ExploreFile );

// Use the following to tell Amibroker what to Include/Exclude and what dates to use
//
// "index", "favorite", "market", "group", "sector", "index", "watchlist"
// 0 = include; 1 = exclude
// 0 = all stocks, 1 = current stock, 2 = use filter
// 0 = all quotes, 1 = n last quotes, 2 = n last days, 3 = from-to date
//

// Set Filters
AA.ClearFilters();
// AA.Filter(0,"favorite") = 1; // Try this to load a long ticker which is favorites ^rut
AA.Filter(0,"watchlist") = 9; // 0 = Include; "watchlist" 57 contains the SP500 component stocks
AA.ApplyTo = 2; // 0 = all stocks, 1 = current stock, 2 = use filter

// Set Dates
AA.RangeMode = 3; // 0 = all quotes, 1 = n last quotes, 2 = n last days, 3 = from-to date
//AA.RangeN = 5000;
AA.RangeFromDate = "12/31/2002";
AA.RangeToDate = "12/31/2099";

// ----------------------------------------------------------
// Run exploration, export exploration to csv file
// ----------------------------------------------------------
{AA.Explore();}

{AA.Export( ExportFile );

AB.SaveDatabase();

AB.RefreshAll();}

//AA.ShowWindow(0); // 0 = all stocks, 1 = current stock, 2 = use filter

// The End
// ----------------------------------------------------------



__________ Information from ESET Smart Security, version of virus signature database 4628 (20091122) __________

The message was checked by ESET Smart Security.

http://www.eset.com


__________ Information from ESET Smart Security, version of virus signature database 4628 (20091122) __________

The message was checked by ESET Smart Security.

http://www.eset.com


__._,_.___


**** 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/





Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___