Login Page - Create Account

Support Board


Date/Time: Tue, 07 May 2024 23:58:40 +0000



Different Spreadsheets for Trading

View Count: 658

[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]
Sierra Chart Engineering - Posts: 104368
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]
Sierra Chart Engineering - Posts: 104368
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:

Login

Login Page - Create Account