Jump to content

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


Recommended Posts

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 

 

1667839089_ScreenShot2022-01-24at4_42_54pm.thumb.png.0dae0c369236ee2c70c06077818c71f6.png

 

 

 

 

34107037_ScreenShot2022-01-24at5_00_06pm.thumb.png.52d0254e6c77d8729d2d1d6395fe5ba9.png

Link to comment

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....

image.thumb.png.6d09e670056bdffba8916426da20479b.png

Link to comment

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

 

 

image.png

image.png

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Posts

    • Sainsburys full year earnings and Unilever’s first quarter trading update both say the same thing, UK consumers are in for higher prices. The war in Ukraine, supply chain issues and the effects of ongoing Covid all to blame.      
    • US Dollar (DXY) Daily Price and Analysis US Q1 GDP may stall the greenback’s advance. A 20-year high nears for the US dollar. The multi-month US dollar rally continues with the greenback printing a fresh high today ahead of the first look at US Q1 GDP at 12.30 GMT. The US dollar basket (DXY) has been boosted by renewed weakness in the Euro and the Japanese Yen, as investors move from lower-yielding to higher-yielding currencies, while safe-haven flows continue to benefit the greenback. The US growth release later in the session is expected to show a sharp slowdown from the robust Q4 figure of 6.9%. The markets are currently pricing in growth of just 1% for the first three months of this year, with the slowdown mainly due to a reduction in inventory accrual over the quarter. This release is unlikely to move the greenback, unless there is a large miss or beat, as the Fed believe that 2022 US growth will be robust enough to let them tighten monetary policy sharply without damaging the economy. The latest US Core PCE data – the Fed’s preferred inflation reading – is released on Friday and this may have more effect on the US dollar than today’s GDP data. For all market moving economic data and events, see the DailyFX Calendar. The ongoing US dollar rally has been aided by weakness across a range of G7 currencies including the Euro, the Japanese Yen, and the British Pound. The Euro continues to battle with lowly growth expectations, exacerbated by energy concerns, the British Pound is mired by weak economic data, while the Japanese Yen is in freefall as the BoJ continues with its ultra-loose monetary policy.   The US dollar continues to press higher and looks set to break above 103.96, the March 2020 high. Above here the US dollar would be back at levels last seen nearly two decades ago. The March resistance will likely hold in the short-term, especially with month-end portfolio rebalancing at the end of the week, but US dollar strength is set to continue in the months ahead. USDOLLAR (DXY) WEEKLY PRICE CHART – APRIL 28, 2022 {{THE_FUNDAMENTALS_OF_BREAKOUT_TRADING}} What is your view on the US Dollar – bullish or bearish?   Apr 28, 2022 | DailyFX Nick Cawley, Strategist
    • While Tesla has nothing directly to do with Elon Musk buying Twitter - TSLA stock closed down 12% on news that Musk may have to sell stock and use other holdings to stand against the loan to finalise the purchase of the social media giant.        
×
×
  • Create New...