Support Board
Date/Time: Fri, 07 Feb 2025 18:10:59 +0000
Different Spreadsheets for Trading
View Count: 758
| [2020-06-10 15:04:41] |
| Tom_Tom - Posts: 40 |
|
Hello, i have different Charts with same symbol but different Time and Type. For every chart i have a spreadsheet. Can i put the data in one Spreadsheet for Trading? Or must i solve the problem by another way. I only want to take the signals for Trading, for one symbol, from different Charts with different Time and different Type. Thanks, Tom |
| [2020-06-10 15:12:25] |
| Tom_Tom - Posts: 40 |
|
Oh, i will try "Study/Price Overlay Study"
|
| [2020-06-10 15:51:08] |
| Tom_Tom - Posts: 40 |
|
Oh yes, i think this will work for me! http://www.sierrachart.com/image.php?Image=1591803768204.png No i have a Renko in a Candlestick Chart. Sierra Chart is the best Trading Software EVER!! With TradeStation i had so much problems to take different timeframes for trading. Thanks! |
| [2020-06-10 18:27:36] |
| |
|
Yes you can use the same Spreadsheet. Just use the same spreadsheet name for the Spreadsheet Name setting for the Spreadsheet Study: Chart Studies: Settings and Inputs Tab >> Spreadsheet Name / DLL File and Function Name Make sure each chart is outputting to a different Sheet: Spreadsheet Study Inputs: Chart Data Output Sheet Number We see you are using Interactive Brokers, we strongly recommend that you use the Denali Exchange Data Feed for data: Denali Exchange Data Feed 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: 2020-06-10 18:28:29
|
| [2020-06-10 19:45:19] |
| Tom_Tom - Posts: 40 |
|
Hello, thank you very much for your fast answer! Now i have solved the Problem with the different Spreadsheets. About the Problem with IBRK i have heard this and i am thinking about a change. But i must say since now i never had problems between SC and IBKR. If i am asking to much or if i am annoying, please stop reading NOW and go away. I am using 4 Tick Range and 10 Minutes Candles with 10 Minutes MACD in one Chart. Now i compare the actual MACD Diff with the last MACD Diff of the last 10 Minute Candle. For this i use the Formula in Spreadsheet: =if(and(AA3<>AA5,BA3<BA5),1,if(and(AA3<>AA15,BA3<BA15),1,if(and(AA3<>AA25,BA3<BA25),1,if(and(AA3<>AA35,BA3<BA35),1,if(and(AA3<>AA45,BA3<BA45),1,if(and(AA3<>AA55,BA3<BA55),1,if(and(AA3<>AA65,BA3<BA65),1,""))))))) AA is Open of Candle ( When different open then i know a new Candle is born) BA is MACD For now it's working, but i think there is a Smarter way to do! Normally i need the Data of the Row for the MACD which is about 11 Minutes ago. Thanks Tom |
| [2020-06-10 23:07:47] |
| User857051 - Posts: 10 |
|
I dare say it could be simplified. Are you scalping 4 ticks on a 10 minute chart?
|
| [2020-06-11 04:58:44] |
| |
|
If you do not have problems with Interactive Brokers then just stay. We are just not going to provide technical help for that trading service anymore.
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: 2020-06-11 04:59:01
|
To post a message in this thread, you need to log in with your Sierra Chart account: