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
  • General Statistics

    • Total Topics
      21,203
    • Total Posts
      90,749
    • Total Members
      41,311
    • Most Online
      7,522
      10/06/21 10:53

    Newest Member
    Millers
    Joined 31/01/23 10:12
  • Posts

    • In a week packed with global macro and micro releases, the key events locally are a series of updates on the Australian housing market, which continues to cool as higher interest rates reduce affordability.   Source: Bloomberg   Forex Inflation Currency Interest rate CFD AUD/USD  Tony Sycamore | Market Analyst, Australia | Publication date: Tuesday 31 January 2023  Kicking things off today, housing credit growth for December rose by just 0.3%, the slowest pace since October 2022. At the same time, Retail sales fell by 3.9% in December (vs -0.2% expected), for the most significant monthly fall since August 2020. The fall in December unwinds the 1.4% gain in November, boosted by Black Friday cyber sales. Core Logic Dwelling prices (Wednesday) are expected to show housing prices fell -1.1% in the seasonally quiet month of January, extending the correction that began in May 2022 Building Approvals fell by 9%, following a 56% fall in October. The market is looking for a modest bounce back of +1% in December. Building Approval data is a notoriously volatile data set, and expectations range from -5% to +8% Housing Finance fell for a sixth straight month in November to be 24.8% below the peak of January 2022. The decline is expected to continue in December, with the market looking for a 2.5% fall in December (Friday). Following the release of hotter-than-expected Australian inflation data last week, the RBA is widely expected to lift its official cash rate by 25bp from 3.1% to 3.35% next Tuesday. The interest rate market then has another 50bp of rate hikes priced by August of this year, which would take the cash “peak” rate to 3.85%. The RBA has made clear its “priority is to re-establish low inflation and return inflation to the 2–3 per cent range over time.” While a series of RBA rate hikes in 2023 would be another blow to the housing market, they would be good news for the AUD/USD, already enjoying the tailwinds of the China re-opening and higher commodity prices. Overnight the past 24 hours, the AUD/USD has fallen back to .7050 on soft retail sales data, risk aversion flows, and with the US dollar in demand overnight for month-end rebalancing flows. After reaching and marginally breaching our August .7137 target from this article in Mid-January here last week, we expect to see the current pullback in the AUD/USD continue towards uptrend support at .6900c. At worst, the pullback may extend to the 200-day moving average at .6810 to work off overbought readings and to rebuild energy for its next leg higher towards .7300c. AUD/USD daily chart   Source: TradingView Take your position on over 13,000 local and international shares via CFDs or share trading – and trade it all seamlessly from the one account. Learn more about share CFDs or shares trading with us, or open an account to get started today.
    • Hi All, please kindly note that the integration between Tradingview and IG will be live by April 2023. All the best, OfentseIG
    • ASX 200 afternoon report: 31st of January 2023 ASX 200 market update as of 31st January, 3.30 pm AEDT.   Source: Bloomberg   Forex Indices Shares ASX S&P/ASX 200 Retail  Tony Sycamore | Market Analyst, Australia | Publication date: Tuesday 31 January 2023  The ASX 200 trades 13 points (0.18%) lower at 7468 at 3.30 pm Sydney time. The ASX 200 has reversed lower this afternoon on month-end selling rebalancing flows, and softer-than-expected retail sales and housing credit data for December. Housing credit growth for December rose by just 0.3%, the slowest pace since October 2022. At the same time, Retail sales fell by 3.9% in December (vs -0.2% expected), the most significant monthly fall since August 2020. While these numbers won’t stop the RBA from raising rates next week or ease downside concerns around the Australian housing market or household consumption, they have helped to ease expectations around the RBA’s peak cash rate as it fell from 3.85% to 3.75%. Consumer Staple sector Falling house prices, higher inflation and RBA rate hikes which will weigh on discretionary spending, have been behind the defensive Consumer Staple sector outperforming. Woolworths added 3.2% to $35.88 Coles added 2.45% to $17.77 Metcash added 1.2% to $4.17 Infant formula maker Bubs Australia plunged 9.15% on disappointing sales in China from extended lockdowns. What does soft housing and retail data mean for the AUD/USD? Read Tony's analysis here. IT sector Megaport plunged by 23% to $5.90 following a disappointing quarterly update BNPL stocks Sezzle -7.69% ZIP -3.28% Block -2.37% fell following the release of the weaker-than-expected retail sales numbers, which will weigh on earnings. Financial sector The big banks have reversed lower on the toxic mix of weaker credit appetite and evidence that households are beginning to feel the impact of the cost-of-living pressures. NAB fell -0.38% to $31.71 ANZ fell 0.24% to $24.97 Westpac fell -0.21% to $23.70 CBA is trading flat at $109.77, after making a fresh all-time high earlier today at $110.45. Mining sector A mixed day for the material stocks despite a bounce in China’s PMI data, now in expansionary territory at 50.1 following China’s re-opening in Mid-December. Rio Tinto added 1.35% to $127.37 Fortescue added 0.32% to $22.65 BHP added 0.28% to $49.36 Mineral Resources fell 3.2% to $89.57 Lynas Rare Earths fell 2.94% to $9.43. Technical analysis Over the past five sessions, there has been a notable loss of upside momentum in the ASX 200 - understandable after a storming run higher in January. Additionally, the ASX 200 is overbought, and for the Elliott Wave enthusiasts, there is a five-wave advance from the October 6411 low on bearish RSI divergence, which warns of a possible pullback. We continue to favour trimming longs ahead of the bull market 7632 high and looking to either buy a sustained break of the 7632 high or a pullback into the 7200/7000 support area. ASX 200 daily chart   Source: TradingView The figures stated are as of January 31st, 2023. Past performance is not a reliable indicator of future performance. This report does not contain and is not to be taken as containing any financial product advice or financial product recommendation. Take your position on over 13,000 local and international shares via CFDs or share trading – and trade it all seamlessly from the one account. Learn more about share CFDs or shares trading with us, or open an account to get started today.
×
×
  • Create New...