Support Board

Date/Time: Sat, 20 Apr 2024 10:48:02 +0000

Post From: Referencing cells from other spreadsheets

[2017-11-29 05:16:15] Link To Thread - Link To Post [Go To First Post]
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