Support Board
Date/Time: Thu, 28 Nov 2024 11:04:29 +0000
[User Discussion] - Slope of 50MA results not correct using Spreadsheet Trading
View Count: 332
| [2023-05-04 05:24:04] |
| Czubdaddy - Posts: 8 |
|
I tried my new spreadsheet automated trading strategy today for the first time live today. I noticed my trades were going in and out pretty randomly. Though for some reason I did make some money today, the trades weren't following my strategy/formulas. I started poking around and found some random numbers in my Slope of 50ma column. Some numbers looked right but then some numbers were completely out of whack. I can see the 50 MA rising up at a good angle but instead of numbers like 765, 800, and 1000 for the slope of the line, I was getting -34324538, 443434243, and then sometimes 0. I modified my formula, then the numbers in the 50 MA slope column recalculated and looked fine. I then reverted back to my original formula and the column recalculated and then looked fine. I am not sure what happens when trading live for the slope column. Here is my calculation: =slope(id4.sg1@3:id4.sg1@6,A3:A6) Because my 50ma slope column numbers were all over the place, my trades were all over the place too. |
| [2023-05-04 15:23:53] |
| Sawtooth - Posts: 4120 |
|
This might be a calculation precedence issue. Chart Studies: Study Calculation Precedence And Related Issues |
| [2023-05-04 15:42:10] |
| Czubdaddy - Posts: 8 |
|
The calculation order was set to 3. I changed to 1. I am going to increase the number of bars in the calculation and see what happens. Still getting numbers like these this morning and the slope of the 50ma is going up visually. I have another instance of SC running on the same computer with the same calculation and the numbers look good. Also, My 5ma slope and 15ma slope are not correct either. Slope 50MA AG -1879843.6364669907 1880275.6364660352 5640826.931068501 0 -5638902.315652362 -1879634.0993093622 -3758354.851058739 3759572.659620188 1879329.6520931276 5637988.977938876 -5635891.4134671455 Date Time Of Last Edit: 2023-05-04 16:11:06
|
| [2023-05-04 20:14:46] |
| Sawtooth - Posts: 4120 |
|
Does a Chart >> Recalculate fix the values?
|
| [2023-05-05 00:09:54] |
| Czubdaddy - Posts: 8 |
|
Yes. Chart>> Recalculate made the Slope 50MA column look better. But probably the only way to tell if that works permanently is to wait for the market open tomorrow. Thanks!
|
| [2023-05-05 03:06:24] |
| Sawtooth - Posts: 4120 |
|
If a recalc will fix it, the problem is likely a calculation precedence issue. Refer to the link in post #2. If can't be resolved with the those things mentioned at the link, a workaround is to add the Chart Recalculation - Periodic study. |
To post a message in this thread, you need to log in with your Sierra Chart account: