Support Board
Date/Time: Thu, 28 Nov 2024 14:03:23 +0000
Post From: Slope of 50MA results not correct using Spreadsheet Trading
| [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. |