Hello Bert:  Unless you're really interested in working with jScript you can do 
clear and build without it. 
Something I put together using Bruce's FT utilities.  As the instructions say, 
careful what your paramlist in the 
Autoanalyzer function is set to, cause it will erase the number that resides 
there. 

Joe 

// Builds a watchlist from a FastTrack Family
// May 2005  JEL 
// Uses the Bruce Robinson's utilities to get a family from the
// FastTrack data base 
// Will look in C:\FT\FTDEF   in USERDEF and in FT4WIN for the family named
// in the parameter list below. 
// Careful of what watchlist you point this to because it will empty it first
// then fill it with the FT Family
// How to Run in Autoanalyzer window
// 1) Set RANGE to LAST QUOTATIONS = 1
// 2) Set APPLY TO CURRENT SYMBOL a stock with lots of data bars/history a 
money market or XOM
// 3) Select PARAMETERS button and ENTER the Watchlist LIST you want to ERASE 
and REFILL
// 4) Select FastTrack Family   jerryall   or myfam  upper or lower case. 
// 5) Press SCAN, to transfer the tickers from the FT FAM to the WATCHLIST of 
your choosing 

#pragma nocache
#include <FT-Utilities8.afl>

script = GetScriptObject(); 
WLNum = Param("Watchlist Number",7,1,60,1);
FamName= ParamStr("FT Family Name","BD-Junk");  // Looks in FTDEF, USERDEF and 
FT4WIN 

if ( Status("action") == 3 )
{ 
 // ****************  File Ops Clears and Rebuilds a Watchlist 
********************
 
 currentlist    = CategoryGetSymbols( categoryWatchlist, WLNum );
 for (i = 0; (member = StrExtract(currentlist, i)) != ""; i++)
  CategoryRemoveSymbol( member, categoryWatchlist, WLNum );
 
 // **************** Get the FT Family 
**********************************************
 List = script.FTGetFam(FamName);   
 for( i = 0; ( sym = StrExtract( list, i ) ) != ""; i++ )
 {
 CategoryAddSymbol(sym,categoryWatchlist,WLNUM); 
 }
 
 Buy=Sell=0;  // this fakes out the AmiBroker AutoAnalyzer
 //           and lets you run the program without an error indication. 
}


  ----- Original Message ----- 
  From: bistrader 
  To: [email protected] 
  Sent: Wednesday, November 25, 2009 9:29 AM
  Subject: [amibroker] EMPTY A WATCHLIST WITH JAVA SCRIPT QUESTION


    
  I am working on a Java Script and am taking one step at a time. I want this 
section of the js to empty a watchlist. I have googled a lot and have commands 
that are javascript and visual basic. This is my error, but I am learning. Here 
is what I have on this should so far. Help appreciated.

  // emptyWatchlist.js

  // This Java Script file should:
  // 1. Load a Database
  // 2. Call a function to empty a watchlist. This function ...
  // a. Creates an afl
  // b. Runs an exploration on this afl to empty watchlist 10.
  // THIS AFL DOES NOT WORK YET
  // ----------------------------------------------------------
  // 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");

  // ----------------------------------------------------------
  // Load Reference Ticker into AmiBroker
  // ----------------------------------------------------------
  AB.ActiveDocument.Name = "RUT-I"; // Set RUT-I as reference ticker

  // ----------------------------------------------------------
  // Empty Watchlist 10
  // ----------------------------------------------------------
  var WatchlistNumber = 10

  WLEmpty_Directory = "C:\\Amibroker\\Temp\\";
  WLEmpty_ExploreFileName = "Empty_Watchlist.afl";
  WLEmpty_ExploreFile = WlEmpty_Directory + WLEmpty_ExploreFileName; 

  emptyWatchlist.call(10);
  //Call emptyWatchlist; // does not work?

  // ----------------------------------------------------------
  // Afl Code to Empty a Watchlist
  // ----------------------------------------------------------
  var Emptya = "list = GetCategorySymbols( categoryWatchlist, ";// Add 
watchlist number later
  var Emptyb = " );"; // Use Chr(34) later to add quotes
  var Emptyc = "for( i = 0; ( sym = StrExtract( list, i ) ) != ";
  var Emptyd = "; i++ )";
  var Emptye = "{";
  var Emptyf = " CategoryRemoveSymbol(sym, categoryWatchlist, ";
  var Emptyg = " );";
  var Emptyh = " Filter=1;";
  var Emptyi = "}";
  var Emptyj = "AddTextColumn(sym ,";// Use Chr(34) later to add quotes
  var Emptyk = "Ticker";
  var Emptyl = ");";

  // ----------------------------------------------------------
  // Function to create an afl that will Empty a Watchlist
  // ----------------------------------------------------------
  function emptyWatchlist
  {
  Dim bolResult
  Dim FrmlaFile

  var Result = WSH.popup("Emptying a Watchlist")

  var FrmlaFile = FS.CreateTextFile(WLEmpty_ExploreFile, True)

  With FrmlaFile
  .WriteLine Emptya + cstr(WatchlistNumber) + Emptyb
  .WriteLine Emptyc + Chr(34) + Chr(34) + Emptyd
  .WriteLine Emptye
  .WriteLine Emptyf + cstr(WatchlistNumber) + Emptyg
  .WriteLine Emptyh
  .WriteLine Emptyi
  .WriteLine Emptyj + Chr(34) + Emptyk + Chr(34) + Emptyl
  .Close
  End With

  Set FrmlaFile = Nothing

  With AA
  .ApplyTo = 1;
  .RangeMode = 2;
  .RangeN = 1;
  .ClearFilters();
  .Filter(0, "watchlist") = WatchlistNumber
  bolResult = .LoadFormula(WLEmpty_ExploreFile)
  If bolResult Then
  .Explore();
  End If
  End With

  AB.RefreshAll()

  //End function
  }

  // That is it.



  

Reply via email to