I forced the row count to the second column over so that AmiBroker does not empty the watchlist. It appears that AmiBroker is coded to assume that tickers are in the first column.
Also, the 4 step process that I addressed below does not work. It appears that AmiBroker processes on the tickers in a watchlist without regard to how the user has them ordered, but rather based on alphabetical order. So, there is no way to find out, say, what ETF ticker is ranked number 20 on a watchlist of ETFs ranked based on UPI other than to count down manually from the exploration. Yes, one can export to Excel but when doing a lot of these this extra step takes too much time. A 'suggestion' was submitted to AmiBroker to allow the user to add line (row) numbers to the Exploration anytime (e.g., say after a UPI ranking, or after a CAR/Mdd ranking, or after a CAR ranking) so one can see the ranking numbers from 1 to the end. --- In [email protected], "bistrader" <bistra...@...> wrote: > > I believe I found a problem with one of AmiBroker's Automatic Analysis > features. The feature, 'Replace Watchlist with the Results', allows one to > create an exploration of a watchlist, sort the watchlist say on UPI, and then > replace the original watchlist with this UPI ranked ticker list. > > However, I found that when I added a number count as the first column, using > he following code, the AA feature empties the watchlist. Nothing. Gone. > Empty. I do not believe it should do this and am guessing it does it because > I added '#' as the first column and not the ticker as the first column. > > ticknum = Status("stocknum") + 1; > Width_Number = 25; > AddColumn(ticknum,"#", 3.0, colorDefault, colorDefault, Width_Number); > > I added the '#' column as AmiBroker does not have a feature allowing a user > to rank an exploration first and then tell AmiBroker to add the rank order > number ('#'). That is, it is nice to look down the list to see that ticker > xyz is number 10 based on UPI. So, the only way around this to ... > > a) Do an exploration on a watchlist providing the # column. > b) Click on UPI to rank this list from highest to lowest, which, screws up > the # column. > c) Click and replace the watchlist with the results. > d) Do exploration again so that top UPI is #1 all the way to lowest UPI being > the last number. > > I would prefer to do all of this in one step, rather than 4 steps, but, and > again, AmiBroker does not have a feature as of yet allowing one to add a > number column AFTER a column is ranked. > > Comments appreciated. >
