****Please help understand calculation of daily % change & if possible data error?

[Nostradamex]

Hey guys,

Please help me understand the way which the change and % change are calculated? I understand the candle sticks are based on the time period i.e. daily however the changes do not seem to make sense to me at the moment. I have attempted to derive the use % change from close to close between days, however the numbers do not match up. 

 

I.e. Codan trading on the ASX at close today (24/1/22) had a change of -$0.005 or -0.06%, however the candle stick shows open $8.24 and close $8.39 detailing a change 1.82% during the day, now the trading day prior (21/1/22) close was $8.38 detailing a total change of 0.12% with todays close... this is where I get lost as none of the fluctuations make sense unless I am missing a trick here...

 

***In addition while organising this post I noticed that the Codan data changed? The open price was wildly different between my 2x screen shots

 

Any help understanding this would be greatly appreciated 

 

Regards 

 

 

 

 

 

[Paul12345]

I had an alert notification set up for movement above 3% on Wisdom Tree Leveraged WTI Crude Oil, it triggered this morning (08:00:12 - 21 Jan 2022) stating it had moved 3.28% in a day, yet it appears to have only moved 0.64% from 1310 to 1318 on the charts???

I am therefore also very interested to know where these percentage numbers come from if anyone knows....

[AndaIG]

Hi @Nostradamex

Thanks for the query. 

Change will be calculated from the closing mid price today minus closing mid price on previous day. Using Codan as an example:

Closing Mid price Friday: 8.385

Closing Mid price Today: 8.380

Difference between the two -0.005

To calculate the percentage change: -0.005/8.385= -0.06%

In addition your two screenshots are on different timeframes. i.e. monthly and daily. Thus they are showing opening last traded price for the month and opening last traded price for the day. 

All the best, 

Anda

 

 

[Nostradamex]

Hi Andal, 

Thanks so much for the explanation! This clears up the discrepancies and apologies I must've missed that cross check when refreshing the screen 

Best regards

 

 

[Nostradamex]

Hi Andal, 

Could you please confirm how the Closing Mid price is take? Is it just the close? 

 

Thanks in advance