Login Page - Create Account

Support Board


Date/Time: Thu, 26 Sep 2024 23:30:50 +0000



excel spreadsheet and values on charts

View Count: 1499

[2019-04-04 16:16:54]
User918738 - Posts: 31
Hi,

Is it possible to take data from the excel spreadsheet(or SC spreadsheet) and post it above the price bars on a chart. I have formulas that kick numerical values for each bar in the cells and i would like to display this numerical values from spreadsheet on to a chart.

Thanks in advance!
[2019-04-04 18:21:56]
John - SC Support - Posts: 34744
It cannot be done from a standard Spreadsheet, but you can do it using the Spreadsheet Study along with the Study Subgraphs Above/Below Bar as Text study. Just be sure the results are in one of the formula columns (default of columns K through Z), and then reference the appropriate subgraph in the Study Subgraphs Above/Below Bar As Text study.

Here is the documentation for the Spreadsheet Study:
Using the Spreadsheet Study: Step By Step Instructions to use the Spreadsheet Study

Here is the documentation for the Study Subgraph Above/Below Bar as Text study:
Study Subgraph Above/Below Bar as Text
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2019-04-04 20:16:55]
User918738 - Posts: 31
Sweet...thanks John!

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account