Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Wed, 08 May 2024 14:23:49 +0000
Post From: Accing study data from a preadsheet?
| [2014-10-17 23:20:55] |
| Sawtooth - Posts: 3993 |
|
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@3See this thread: New Non-CLR Spreadsheet Study Study Reference Method |