Welcome Guest! To enable all features please Login or Register.

### Notification

Error

 Previous Topic Next Topic
 Redhorse #1 Posted : Thursday, October 27, 2022 9:43:49 PM(UTC) Rank: NewbieGroups: Registered Users, SubscribersJoined: 3/16/2016(UTC)Posts: 3 HiCan anybody help me with this? I use two moving averages on my charts - a 10 and a 20 period exponential moving average based on closing prices. But i have just noticed that when i run an exploration with these values being output in two of the columns the values i get are totally different to those on the chart. The formulas i use in the exploration is just (Mov(C,10,E)) and (Mov(C,20,E)).Does anybody know what might be causing the value for the same variable to be different in an exploration than it is on the chart?
 Wanna join the discussion?! Login to your Discussions forum accountor Register a new forum account.
 MS Support #2 Posted : Thursday, October 27, 2022 10:42:05 PM(UTC) Rank: Advanced MemberGroups: Moderators, Registered, Registered Users, SubscribersJoined: 10/8/2010(UTC)Posts: 1,927Thanks: 85 timesWas thanked: 154 time(s) in 150 post(s) Originally Posted by: Redhorse HiCan anybody help me with this? I use two moving averages on my charts - a 10 and a 20 period exponential moving average based on closing prices. But i have just noticed that when i run an exploration with these values being output in two of the columns the values i get are totally different to those on the chart. The formulas i use in the exploration is just (Mov(C,10,E)) and (Mov(C,20,E)).Does anybody know what might be causing the value for the same variable to be different in an exploration than it is on the chart? Hello,The most likely issue here is that the Explorer by default is set to "Load Minimum Records" (this is useful for ensuring maximum speed of your exploration). This isn't a problem with most formula functions, but with exponential calculations in particular, these calculations carry a bit of historical data into the current values when you load more data. You don't necessarily need to load the exact amount of data that you load in a chart (I've heard recommendations of about 20% more data than the minimum periods in your formulas) but to rule out this issue you might want to try increasing the Explore Data Loading to something like 500 or 1250 records (You can try lower numbers if you want to keep exploration speeds maximized). Given the relatively small number of periods in your formulas you could probably just use 100 records and still be fine in getting matching results.Edited by user Thursday, October 27, 2022 10:43:29 PM(UTC)  | Reason: Not specified
 Users browsing this topic
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.