Support Board
Date/Time: Mon, 23 Dec 2024 11:23:02 +0000
Post From: Spreadsheet to chart plot
| [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. |