Support Board

Date/Time: Thu, 16 May 2024 17:47:17 +0000

Post From: Simultaneous Signals and Orders from Single Spreadsheet

[2018-04-29 02:25:08] Link To Thread - Link To Post [Go To First Post]
QTrader08 - Posts: 5
Hi, My issue can be summarized as follows: Note: I've reviewed the documentation concerning spreadsheet functions, using the same spreadsheet for multiple charts, erased formulas, replay backtesting,etc. Goal: To generate signals based on two charts and place orders on both charts simultaneously via spreadsheet. 1)created individual spreadsheet and added it to two different charts 2)each chart formula source is set to the source of input(i.e. Sheet 1 has formula source of #1, etc) 3)to get the value for each of the two charts in each of the two sheets, I used an overlay study; Thus, one of the formulas was calculated based on the data from the actual chart and that of the chart overlaid; This was true across both sheets. (ex. Chart 1 has Overlay of Chart 2, and Chart 2 has Overlay of Chart 1; then the spreadsheet is applied to both Chart 1 and Chart 2, and formulas are derived on each separate sheet) 4) Formulas were calculated in Sheet 1 and Sheet 2 based on the input source of each sheet (i.e. Chart 1 and Chart 2) and used the prices of Chart 1 and Chart 2(and vice versa)... 5) Formulas are erased when attempting to conduct backtest; How do I use data from 2 different charts to generate signals/formulas and then place orders simultaneously on both charts based on the same signal via a spreadsheet?