Login Page - Create Account

Support Board


Date/Time: Thu, 19 Apr 2018 21:08:56 +0000



Post From: Referencing cells from other spreadsheets

[2017-11-29 05:16:15]
User606491 - Posts: 66
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