Support Board
Date/Time: Fri, 17 Jan 2025 06:33:10 +0000
Post From: Referencing cells from other spreadsheets
| [2017-11-29 05:16:15] |
| User606491 - Posts: 164 |
|
How do I reference cells between spreadsheets? I would like to aggregate calculations from across multiple spreadsheets, then use these calculations to prioritize which symbols should be traded. The documentation I've seen requires the use the study/price overlay tool. However, the cells I would like to reference are not first-order outputs from the study/price overlay, but rather derived calculations. Example: 1. A strength of trend metric is calculated by combining X and Y studies 2. I would like to aggregate this metric into a "master spreadsheet" for all symbols in my universe 3. Based on prioritization system, I would then like to send Buy/Sell signals back to each symbol-specific spreadsheet How do I reference cells between spreadsheets? thank you, Eric |