Support Board
Date/Time: Mon, 03 Mar 2025 15:20:04 +0000
Post From: The name of the contract in the spreadsheet?
| [2019-06-04 23:43:50] |
| Sawtooth - Posts: 4179 |
|
How to create a table of contract names?
1. Focus the spreadsheet and go to 'Spreadsheet >> Add Sheet' and give it an unique name, e.g. Rollovers.This will add a blank sheet to the spreadsheet that is not associated with a chart. 2. On the new blank sheet, in column A, list rollover dates, and in column B list the new symbol for each date. In column A, put the dates in descending order (with the current date/symbol in row 1), and use this date format: yyyy-mm-dd 3. In a Formula Column on the chart's sheet, use a formula like this: =IF(INT(A3)>=Rollovers!A$1,Rollovers!B$1,IF(AND(INT(A3)<Rollovers!A$1,INT(A3)>=Rollovers!A$2),Rollovers!B$2,IF(AND(INT(A3)<Rollovers!A$2,INT(A3)>=Rollovers!A$3),Rollovers!B$3,0)))
This formula will return the three most recent symbols. To return more symbols, append the formula with additional IF statements.
|