Support Board
Date/Time: Tue, 26 Nov 2024 02:40:27 +0000
Post From: Automatic date exclusion of Rollover week from Charts
| [2024-01-28 04:31:19] |
| Sawtooth - Posts: 4120 |
|
How do I check the symbol name in spreadhsheet formula study?
These are the only available Base Graph Identifiers in Simple Alerts:Study/Chart Alerts And Scanning: Available Main Price Graph Identifiers/Variables The symbol is not one of them. Additionally, the Spreadsheet Formula study cannot return text. (Despite its name, the Spreadsheet Formula study is not a spreadsheet study, and furthermore not all spreadsheet functions are supported.) All 3 spreadsheet studies have the symbol in cell J40. Based on your questions in the thread, the level of sophistication of your system is pushing the limits of Simple Alerts. This might be a good time to move up to the Spreadsheet System for Trading study. But if you want a workaround, you could number each symbol: - Add the Spreadsheet Study study, and Hide the study. - Set the Number of Rows to 40. - Put something like this in cell K3: =IF(LEFT($J$40,2)="ES",1,IF(LEFT($J$40,2)="NQ",2,... - Then reference SG1 of this spreadsheet study. (Column K is SG1) |