Support Board
Date/Time: Thu, 09 Jan 2025 08:24:06 +0000
Post From: Back Testing: spreadsheet trading study with various range bar charts info
| [2016-07-13 15:18:40] |
| User94740 - Posts: 333 |
|
I am currently trying to backtest using multiple charts with different range bar settings. I had hoped I could use a spreadsheet study for each chart and reference the other spreadsheets, but according to sc, this is opposite the case since a spreadsheet can only reference other sheets within the spreadsheet. Therefore I tried to use either the smallest or the largest setting for a spreadsheet study whilst incorporating study/price overlays for the other charts in order to place all relevant information in one spreadsheet. This had also failed, because the chart with the spreadsheet had recognized the other chart's last and open information incorrectly and thus gave incorrect buy or sell signals. In closing, I hope I am doing something wrong or there is another possibility to achieve my study goal. thx as always
|