Support Board
Date/Time: Tue, 26 Nov 2024 20:15:22 +0000
Post From: sort of a statete machine in a spreadsheet
| [2014-06-09 11:48:13] |
| eagle - Posts: 92 |
|
1. They're any available "Formula Column". The Formula Columns are from column "O" thru to the "Number Of Formula Columns" configured in the spreadsheet Study Settings. 2. My personal criteria in the spreadsheet I was using as an example for a BuyExit/SellExit without the additional qualifiers. Ignore that. I suppose I should have written: =AND(NOT(M3),{criteria for a Buy Exit},AW3)
3a. MATCH(lookup_value, lookup_array, [match_type]). In cell AU3, for example, lookup the lookup_value "TRUE" in lookup_array "K4:$K$300" and match the first value that is exactly equal to "TRUE" (without the quotes), specified by match_type "0". MATCH returns the relative position of the lookup_value in the lookup_array; in other words, MATCH returns the number of rows since the last buy entry signal, since column K is the SC Buy Entry Column. Google "excel formula match" (without the quotes). 3b. So, the formula in cell AU3 returns the number of rows since the Last Buy in column K. The formula in cell AW3 returns the number of rows since the Last Sell in column M. Whichever return is a smaller number indicates whether the current mode is Buy Mode or Sell Mode. Chances are my method is more compute intensive than Tom's method or the method mentioned under Locking the State of a One Time Condition on this page: http://www.sierrachart.com/index.php?l=doc/doc_WS_AddInfo.html. It also contains no error checking in case there's no match. But I didn't want to have any circular references. Date Time Of Last Edit: 2014-06-09 11:50:03
|