Home >> Support Board

Support Board

Date/Time: Mon, 29 Apr 2024 13:00:56 +0000

How to Post a Message for Support

[Programming Help] - Simultaneous Signals and Orders from Single Spreadsheet

View Count: 746

[2018-04-29 02:25:08] #1 [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?

[2018-04-29 15:13:32] #2 [Go To First Post]
QTrader08 - Posts: 5
UPDATE: Okay I sorted the issue. I was adding the overlay studies as mentioned in the documentation. My issue was I used data from 2 different charts and created an initial formula from these and the remaining formulas were manually derived(i.e. taking values from the initial formula and creating new formulas). The initial formula which was created using the ID of the charts was never erased but the new formulas were constantly erased. SOLUTION: I had to find studies that represented the formulas that I was creating manually and then add those to the chart and reference the ID and create the formulas that way. I did this for both Sheets in the Spreadsheet and the formulas remained. Was also able to trade multiple charts simultaneously.

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