Support Board

Date/Time: Sun, 19 May 2024 17:52:11 +0000

Post From: Different Spreadsheets for Trading

[2020-06-10 19:45:19] Link To Thread - Link To Post [Go To First Post]
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