Support Board
Date/Time: Sat, 08 Feb 2025 05:04:35 +0000
Floating Spreadsheet Cells
View Count: 528
| [2020-06-23 21:47:58] |
| User606491 - Posts: 164 |
|
Is it possible to have floating spreadsheet cells on the trade chart that link to the formula source sheet? I look at a portfolio of symbols. Each symbol has a chart and a concurrent spreadsheet. Certain inputs (i.e. margin requirement, % Capital at risk) are specific to each symbol, and not global across the portfolio (so I can't use the global formula source sheet). Currently, for each symbol, I must manually find the spreadsheet via the pulldown menu, then enter the trade specific criteria. This is inefficient and error-prone. Ideally, I would have 2-3 pre-linked floating cells on the trade chart that would allow me to directly update the corresponding spreadsheet. I would then be able to manage my global inputs from the global formula source sheet and my symbol/trade- specific inputs from the chart itself. Is this possible? Other related questions: 1) How do other traders manage the requirement for entering trade or symbol specific inputs? 2) Can the margin requirement be referenced as a study (similar to account balance)? Thank you |
| [2020-06-24 01:03:44] |
| Sawtooth - Posts: 4173 |
|
You can add a blank sheet that is not associated with a chart, and create a table of all the symbols with their respective inputs. You can reference cell J40 from the chart's sheet to get the symbol, then reference the input cells from the chart's sheet. Go to Spreadsheet >> Add Sheet and give it a unique name. It will appear in the dropdown list. |
| [2020-06-24 01:24:38] |
| User606491 - Posts: 164 |
|
Perfect. This will do. Thanks Tom.
|
To post a message in this thread, you need to log in with your Sierra Chart account: