Support Board

Date/Time: Thu, 28 Nov 2024 00:34:46 +0000

Post From: Accing study data from a preadsheet?

[2014-10-17 23:20:55] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4120
Can someone tell me how to plot SG1, SG4 and SG5 in columns K, L and M? In the New Spreadsheets version: In cell K3: =AA3 or =ID1.SG1@3 In cell L3: =AD3 or =ID1.SG4@3 In cell M3: =AE3 or =ID1.SG5@3 where SG1 is in column AA, SG4 is in column AD, SG5 is in column AE And is there a way to only display the Close value in the spreadsheet? In cell N3: =E3 or =ID0.SG4@3 See this thread: New Non-CLR Spreadsheet Study Study Reference Method