Support Board
Date/Time: Sat, 26 Sep 2026 02:47:18 +0000
Post From: Plotting from Spreadsheet Study
| [2026-09-25 18:49:13] |
| User841161 - Posts: 351 |
|
Spreadsheet Study shows NaN when using Independent left-side scale I have a /CL chart with a Spreadsheet Study in Chart Region 1. SG4 of the Spreadsheet Study contains an adjusted USO price series and plots correctly when the study Scale Range is set to Automatic. I want /CL to use the right-side scale and SG4 (Adjusted USO) to use an independently scaled left-side scale. I have: - Chart Settings → Scale → Use Left Side Scale = Yes - Main Price Graph → Automatic - Spreadsheet Study → Scale Range = Independent - Spreadsheet Study → Use In Left Side Scale = Yes - SG4 Draw Style = Line When I change the Spreadsheet Study from Automatic to Independent, SG4 disappears and the left-side scale displays NaN. When I change it back to Automatic, SG4 immediately displays correctly with valid values around 149. The spreadsheet cells feeding SG4 contain valid numeric values with no apparent errors. Is there another setting required for a Spreadsheet Study to use Independent scaling on the left side in the same chart region as the Main Price Graph? |
 Main_Automatic_Spreadsheet_Independent.png / V - Attached On 2026-09-25 18:48:49 UTC - Size: 25.18 KB - 5 views MainChart_Automatic_SpreadsheetStudy_Automatic.png / V - Attached On 2026-09-25 18:48:57 UTC - Size: 33.29 KB - 4 views |