Support Board
Date/Time: Mon, 23 Dec 2024 11:20:32 +0000
[User Discussion] - Spreadsheet to chart plot
View Count: 4628
| [2015-09-18 14:37:58] |
| pismo10 - Posts: 159 |
|
If I had a spreadsheet that generated a list of times in a column, could I have these times plotted as vertical lines on another chart automatically, say a 2min ES chart? Thanks Maybe a dozen times generated each morning before the open. Date Time Of Last Edit: 2015-09-18 14:38:41
|
| [2015-09-18 15:16:21] |
| Sawtooth - Posts: 4141 |
|
I think it could be done, but the only vertical Draw Style available is Background, so it would be a vertical band instead of a vertical line.
|
| [2015-09-18 17:40:24] |
| |
|
The Spreadsheet Study is designed to draw Subgraphs on to the chart that it is applied to. But you can use the Study/Price Overlay study to overlay these Spreadsheet study Subgraphs it on another chart: https://www.sierrachart.com/index.php?page=doc/helpdetails28.html Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2015-09-18 19:00:33
|
| [2015-09-18 18:46:51] |
| pismo10 - Posts: 159 |
|
A spreadsheet study takes data from a chart and places it in a spreadsheet. I am trying to do the opposite. Thanks |
| [2015-09-18 19:03:34] |
| |
|
The Spreadsheet Study does both: http://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudy.html Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2015-09-18 19:03:49
|
| [2015-09-19 18:25:26] |
| pismo10 - Posts: 159 |
|
Getting nowhere...Any more help appreciated. Reading everything and have yet to find anything simple like "Plotting spreadsheet data to a chart" or something simple and straight forward like that..
|
| [2015-09-20 00:55:32] |
| Sawtooth - Posts: 4141 |
|
-It's not possible to plot data to a chart from an external Excel spreadsheet. -To plot spreadsheet data to a chart you must use a spreadsheet study and the data must be in Formula Columns K-Z...BR. -To plot spreadsheet data to the same chart where the spreadsheet study exists, the data must be in Formula Columns K-Z...BR. -To plot spreadsheet data from a spreadsheet study on a different (source) chart, add the Study/Price Overlay study to the destination chart and reference the spreadsheet study on the source chart. All spreadsheet Formula Columns (subgraphs) will be overlaid. -If you could create a list of times in column H of a spreadsheet study on the destination chart, you would not need to overlay a spreadsheet study from the source chart. -If you must create a list of times in column H on the source spreadsheet study, you would need to reference column H in one or more Formula Columns so that the data could be overlaid on the destination chart. There are other scenarios, but this should give you an idea of the functionality of spreadsheet studies regarding overlaying data. Other challenges will be writing formulas that will go TRUE at the desired bar, and this would depend on the bar periods of the source and destination charts, among other things. |
| [2015-09-20 01:00:34] |
| |
|
Hopefully post #7 is helpful here.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2015-09-20 13:29:11] |
| pismo10 - Posts: 159 |
|
Thanks, big help. So I am using an internal Sierra spreadsheet. My data is in K9 thru K17. I tell it to start at row 9 which is an option thank god. All I get is a line of zeros...Thoughts Thanks |
| [2015-09-20 14:12:34] |
| Sawtooth - Posts: 4141 |
|
-Formulas in Formula Columns must be entered in row 3. -Formula columns will auto-fill to rows below when a formula is entered in row 3. Row 3 is the current chart bar, rows below are previous chart bars. -Since each row is a chart bar, Formula Columns are for formulas that relate to chart bars. Columns A to G are also chart bar specific. -Column H is not associated with chart bars. It can be used for calculations that are not chart bar specific. Use column H instead for your list of times. Then with a formula in K3, use absolute references to values in column H. See this: http://www.sierrachart.com/index.php?page=doc/doc_Spreadsheets.html#RelativeAbsoluteReferences You'll want to compare times in column H with times in column A, however column A also includes the date. To remove the date, include something like this in your K3 formula: =A3-INT(A3) When comparing times, you may also need to deal with the imprecision of floating point numbers. See this: http://www.sierrachart.com/index.php?page=doc/doc_StudiesSystemsAlerts.php#ImprecisionOfFloatingPointNumbers |
| [2015-09-20 17:34:25] |
| pismo10 - Posts: 159 |
|
Thanks but I give up. I will never get it to plot vertical lines anyhow. I cant get it to plot anything but zeros. Should be simple but programmers...a breed of their own..Back to manual and looking for other charting packages.
|
To post a message in this thread, you need to log in with your Sierra Chart account: