Reporting & Analytics

NOK exchange rates and bond yields

On the development of SWESTR in May 2024

Blog

On the development of SWESTR in May 2024

We analyse the development of the Swedish krona Short-Term Rate (SWESTR) in May 2024. The SWESTR is a reference rate that can be used for setting rates between banks, and it is based on transactions happening in the financial market. We do the analysis with support from a Power BI report, which we have developed and which is available in our Portfolio. For more information on the SWESTR, please see our previous blog post or the Swedish central bank’s website.

Overview of SWESTR in May 2024

We filter the Power BI report to only show data before the 1st of June 2024. We then see in the picture below an overview of the SWESTR development. As an example, we see that May 2024 ended with the SWESTR at 3.644%. From our blog post on the March development, we notice that this is 25 bps lower than March, which ended at 3.895%. The SWESTR has increased also by 25 bps compared to one year ago.

Summary view of the development of SWESTR since its launch
Summary view of the development of SWESTR since its launch

The chart in the upper-left corner presents averages calculated over 1 to 6 months. We see that all averages are slightly below 4%, just like we concluded in the March blog post. At 15th of May, the policy rate was cut by 25 bps to 3.75% by the Riksbank. This will likely be reflected in coming months in the 1 – 6 months averages presented above. It is already seen in the 25 bps decrease of the SWESTR to 3.644%.

SWESTR trend

In the bottom left chart, in the picture above, we see that the rate with which the SWESTR increases, has slowed down. At the end of March 2024, the SWESTR was at 3.9%, and it was unchanged compared to the end of Q4 2023.

To further review the trend over time, we zoom in on the development per month, and we remove a filter so that we can see the current average despite Q2 2024 not being concluded. We then see that 7 months in a row ended at 3.9%. The policy rate was increased from 3.75% to 4.00% from the 27th of September 2023. Then it was decreased in May 2024, and consequently the SWESTR decreased as well. The policy rate is at 3.75% and SWESTR ended May approximately 11 bps lower at 3.644%.

The monthly development of SWESTR
The monthly development of SWESTR

Number of transactions and SWESTR volume

We also review the number of transactions and the SWESTR volume in monetary terms. First, we note from the summary picture above, that Q2 2024 had on average 141 transactions happening per day. That was an increase from 97 in Q2 2023 – a 46% increase. The average transaction volume per day decreased from 55.90 BSEK in Q2 2023 to 60.43 BSEK – an 8% increase and approximately 4.5 BSEK higher volume per day. That is a significant increase in volume.

In the chart below, we zoom in on the development of daily number of transactions and daily average volume per month. We see that there is a clear trend where the number of transactions per day is increasing, and there were on average 143 transactions per day in May 2024. Ignoring the first months after the launch, the volume goes up and down between approximately 50 BSEK and 65 BSEK per day. It can be concluded that there are more, but smaller, transactions happening per day now compared to before.

Daily average number of transactions and daily average transaction volume since the launch of SWESTR
Daily average number of transactions and daily average transaction volume since the launch of SWESTR

Summary

The SWESTR remained flat for 7 consecutive months around 3.9%, but in May 2024 it decreased to 3.6%. There are more and more transactions happening each day with the SWESTR – in May on average 143 per day, which is an increase by 54% compared to May last year. At the same time, the average daily volume was 60.2 BSEK in May, which is an increase by 12% compared to May last year.

More blog posts

On the development of SWESTR in May 2024

We analyse the development of the SWESTR in May 2024. We use a Power BI report and also review the...

On the development of the SEK exchange rates & bond yields in May 2024

We analyse the development of the SEK exchange rates & bond yields in May 2024. We use a Power BI...

On the development of the SEK exchange rates & bond yields in April 2024

We analyse the development of the SEK exchange rates & bond yields in April 2024. We use a Power BI...

On the development of the NOK exchange rates & bond yields in March and Q1 2024

We analyse the development of the NOK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of SWESTR in March and Q1 2024

We analyse the development of the SWESTR in March and Q1 2024. We use a Power BI report and also...

On the development of the SEK exchange rates & bond yields in March and Q1 2024

We analyse the development of the SEK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of the SWESTR in February 2024

We analyse the development of the SWESTR in February 2024. We use a Power BI report and also analyse...

On the development of the NOK exchange rates & bond yields in February 2024

In this blog post, we will analyse the development of the NOK exchange rates in February 2024. We...

On the development of the SEK exchange rates & bond yields in February 2024

We analyse the development of the SEK exchange rates and bond yields in February 2024. We use a...

On the development of SWESTR in May 2024 Read More »

NOK exchange rates and bond yields

On the development of the SEK exchange rates & bond yields in May 2024

Blog

On the development of the SEK exchange rates & bond yields in May 2024

We analyse the development of the Swedish krona (SEK) exchange rates and bond yields in May 2024. We do the analysis with support from a Power BI report that we have developed, which is available in our Portfolio. The source of all the data in the report is the Swedish central bank – the Riksbank.

May 2024 exchange rates overview

We start by filtering the report so that only data before the 1st of June 2024 is present in the report. We then go to the page below and expand the table so that the monthly development of the exchange rates is visible. We then click on May and consequently the page updates with May as a filter.

The development of SEK exchange rates in May 2024
The development of SEK exchange rates in May 2024

Zooming in on the chart with percentual change, it looks like the picture below. We see that SEK started the month relatively flat against all currencies except Norwegian krone (NOK) in the report. However around the 14th of May, the SEK started to strengthen against all currencies except NOK. At 15th May 2024, the policy rate was cut by 25 bps by the Riksbank. The SEK ended the month by strengthening against all currencies in the report except NOK. As we see in the table above, all changes were in the range from -5.0% to 1.7%.

The percentual change of SEK exchange rates in May 2024
The percentual change of SEK exchange rates in May 2024

From the table above, we see some notable changes to the SEK exchange rates in May 2024, for example:

  • Strengthening against Chinese yuan (CNY) by 3.6%
  • Strengthening against Japanese yen (JPY) by 5.0%
  • Strengthening against US dollar (USD) by 3.6%
  • Weakening against Norwegian krone (NOK) by 1.7%

2024 year-to-date overview

Zooming in on the table from the picture above, we can see the total development for 2024 year-to-date (YTD). In 2024, SEK has weakened against all currencies in the report except JPY and CHF.

The percentual change of SEK exchange rates YTD in 2024
The percentual change of SEK exchange rates YTD in 2024

Some notable changes to the SEK exchange rates in May 2024 YTD are:

  • Weakening against CNY by 2.0%
  • Weakening against Pound sterling (GBP) by 3.9%
  • Weakening against EUR by 2.4%
  • Weakening against USD by 3.4%
  • Strengthening against JPY by 6.5%

Bond yields in May 2024

We also review the bond yields to explore possible reasons to the changes in the SEK exchange rates. From the picture below, we see that in May (the MTD value), all the SEK bond yields decreased. This is aligned with the cut in the policy rate in May 2024, which was discussed above. The trend in 2024 is clearly that the bond yields have increased, not only for SEK but also for other bonds like GBP and USD.

Summary view of SEK exhange rates and bond yields as of May 2024
Summary view of SEK exhange rates and bond yields as of May 2024

For example, the SEK 2 years yield decreased by 10 bps in May to 2.78%. So far in 2024, it has increased by 49 bps. Compared to 1 year ago, the 5 years yield is flat at just +4 bps, so it means the yield was decreasing in the end of 2023 but has now started to increase again in 2024.

With regards to the bond spreads, that is the difference between bonds with longer duration and bonds with shorter duration, there was some significant change in May, specifically for the 2s10s. The 5 years yield is close to the 10 years yield, so the 5s10s is close to 0%. However, the 2 years yield is higher than the 10 years yield, which is reflected by the 2s10 being at -0.34%. Typically, there is a premium for bonds with longer duration like the 10 years bond so the 2s10s would then be positive instead.

In May, the EUR and JPY 10 years yields increased by 12 bps respective 1 bps. The SEK 10 years yield actually decreased by 8 bps. Despite this, the SEK exchange rate strengthened by 2.2% against EUR and 5.0% against JPY.

Summary

In May, SEK strengthened against many large currencies like EUR, GBP and USD. It strengthened by 5.0% against JPY, 3.4% against USD and it weakened by 1.7% against NOK. In the time period of one month, this is a significant change, in particular the 5.0% strengthening against JPY. With regards to the overall development in 2024, SEK has weakened against many currencies. For example, SEK has weakened against USD by 3.4% and against GBP by 3.9%. Meanwhile, it has strengthened against JPY by 6.5% and by 3.0% against Swiss franc (CHF).

With regards to the SEK bond yields, they all decreased in May. This is in contrast to the overall development in 2024. For example, the 2 years yield decreased by 10 bps in May to reach 2.78% and so far in 2024 it has increased by 49 bps.

In May, the Riksbank cut the policy rate and it influenced the SEK bond yields which decreased at the same time as yields in many other currencies increased.

More blog posts

On the development of SWESTR in May 2024

We analyse the development of the SWESTR in May 2024. We use a Power BI report and also review the...

On the development of the SEK exchange rates & bond yields in May 2024

We analyse the development of the SEK exchange rates & bond yields in May 2024. We use a Power BI...

On the development of the SEK exchange rates & bond yields in April 2024

We analyse the development of the SEK exchange rates & bond yields in April 2024. We use a Power BI...

On the development of the NOK exchange rates & bond yields in March and Q1 2024

We analyse the development of the NOK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of SWESTR in March and Q1 2024

We analyse the development of the SWESTR in March and Q1 2024. We use a Power BI report and also...

On the development of the SEK exchange rates & bond yields in March and Q1 2024

We analyse the development of the SEK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of the SWESTR in February 2024

We analyse the development of the SWESTR in February 2024. We use a Power BI report and also analyse...

On the development of the NOK exchange rates & bond yields in February 2024

In this blog post, we will analyse the development of the NOK exchange rates in February 2024. We...

On the development of the SEK exchange rates & bond yields in February 2024

We analyse the development of the SEK exchange rates and bond yields in February 2024. We use a...

On the development of the SEK exchange rates & bond yields in May 2024 Read More »

NOK exchange rates and bond yields

On the development of the SEK exchange rates & bond yields in April 2024

Blog

On the development of the SEK exchange rates & bond yields in April 2024

We analyse the development of the Swedish krona (SEK) exchange rates and bond yields in April 2024. We do the analysis with support from a Power BI report that we have developed, which is available in our Portfolio. The source of all the data in the report is the Swedish central bank – the Riksbank.

April 2024 overview

We start by filtering the report so that only data before the 1st of May 2024 is present in the report. We then go to the page below and expand the table so that the monthly development of the exchange rates is visible. We then click on April and consequently the page updates with April as a filter.

The development of the SEK exchange rates in April 2024
The development of the SEK exchange rates in April 2024

Zooming in on the chart with percentual change, it looks like the picture below. We see that SEK started the month by strengthening against all currencies except NOK in the report. However around the 10th of April, the SEK started to weaken against most currencies. It ended the month by weakening against all currencies in the report except JPY. As we see in the table above, all changes were in the range from -1.5% to 2.0%.

Zooming in on the development of the SEK exchange rates in April 2024
Zooming in on the development of the SEK exchange rates in April 2024

From the table above, we see some notable changes to the SEK exchange rates in April 2024, for example:

  • Weakening against Swiss franc (CHF) by 1.5%
  • Weakening against Chinese yuan (CNY) by 1.9%
  • Weakening against Euro (EUR) by 1.7%
  • Weakening against US dollar (USD) by 2.0%
  • Strengthening against Japanese yen (JPY) by 1.5%

2024 year-to-date overview

Zooming in on the table from the picture above, we can see the total development for 2024 year-to-date (YTD). In 2024, SEK has weakened against all currencies in the report except JPY.

The year-to-date (YTD) development of the SEK exchange rates in April 2024
The year-to-date (YTD) development of the SEK exchange rates in April 2024

Some notable changes to the SEK exchange rates in April 2024 YTD are:

  • Weakening against CNY by 6.3%
  • Weakening against Pound sterling (GBP) by 6.8%
  • Weakening against EUR by 5.4%
  • Weakening against USD by 7.7%
  • Strengthening against JPY by 2.5%

Bond yields

We also review the bond yields to explore possible reasons to the changes in the SEK exchange rates. From the picture below, we see that in April (the MTD value), all bond yields increased except the SEK 7 years and 10 years yields. This is aligned with the overall development in 2024, where the bond yields have all increased.

Summary view of SEK exhange rates and bond yields as of April 2024
Summary view of SEK exhange rates and bond yields as of April 2024

For example, the SEK 2 years yield decreased by 17 bps in April to 2.94%. So far in 2024, it has increased by 65 bps. Compared to 1 year ago, the 5 years yield is flat at just +2 bps, so it means the yield was decreasing in the end of 2023 but has now started to increase again in 2024.

With regards to the bond spreads, that is the difference between bonds with longer duration and bonds with shorter duration, there was some significant change in April, specifically for the 2s10s. Since the 2 years yield increased by 17 bps while the 10 years yield decreased by 4 bps, the spread decreased by -21 bps. Typically, there is a premium for bonds with longer duration like the 10 years bond, but following the -21 bps change, that is reversed and the 2 years bond now has a 46 bps premium against the 10 years equivalent.

In April, the GBP and USD 10 years yields increased by 29 bps respective 33 bps. The SEK 10 years yield actually decreased by 4 bps. This development can explain the weakening of the SEK against GBP (1.7%) and USD (2.0%) in April 2024.

Summary

In April, SEK weakened against many large currencies like EUR, GBP and USD. It weakened by 1.9% against CNY, 1.7% against EUR and by 2.0% against USD. In the time period of one month, this is not a dramatic change but it is still significant. The development in April is aligned with the overall development in 2024 where SEK has weakened against many currencies. For example, SEK has weakened against USD by 7.7% and against GBP by 6.8%. Meanwhile, it has strengthened against JPY by 2.5% and it is developing similarly to CHF – it has just weakened by 0.2% against CHF.

With regards to the SEK bond yields, they mostly increased in April. This is aligned with the overall development in 2024. For example, the 2 years yield decreased by 17 bps in April to reach 2.94% and so far in 2024 it has increased by 65 bps. However, compared to 1 year ago, it is just 2 bps higher now.

In April, the 5 years and 10 years yields in other currencies, for example in GBP and USD, increased more than SEK. This can explain the SEK weakening in April 2024.

More blog posts

On the development of SWESTR in May 2024

We analyse the development of the SWESTR in May 2024. We use a Power BI report and also review the...

On the development of the SEK exchange rates & bond yields in May 2024

We analyse the development of the SEK exchange rates & bond yields in May 2024. We use a Power BI...

On the development of the SEK exchange rates & bond yields in April 2024

We analyse the development of the SEK exchange rates & bond yields in April 2024. We use a Power BI...

On the development of the NOK exchange rates & bond yields in March and Q1 2024

We analyse the development of the NOK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of SWESTR in March and Q1 2024

We analyse the development of the SWESTR in March and Q1 2024. We use a Power BI report and also...

On the development of the SEK exchange rates & bond yields in March and Q1 2024

We analyse the development of the SEK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of the SWESTR in February 2024

We analyse the development of the SWESTR in February 2024. We use a Power BI report and also analyse...

On the development of the NOK exchange rates & bond yields in February 2024

In this blog post, we will analyse the development of the NOK exchange rates in February 2024. We...

On the development of the SEK exchange rates & bond yields in February 2024

We analyse the development of the SEK exchange rates and bond yields in February 2024. We use a...

On the development of the SEK exchange rates & bond yields in April 2024 Read More »

NOK exchange rates and bond yields

On the development of the NOK exchange rates & bond yields in March and Q1 2024

Blog

On the development of the NOK exchange rates & bond yields in March and Q1 2024

We analyse the development of the Norwegian krone (NOK) exchange rates and bond yields in March and Q1 2024. We do the analysis with support from a Power BI report that we have developed, which is available in our Portfolio. The source of all the data in the report is the Norwegian central bank – Norges Bank.

March 2024 overview

We start by filtering the report so that only data before the 1st of April 2024 is present in the report. We then go to the page below and expand the table so that the monthly development of the exchange rates is visible. We then click on March and consequently the page updates with March as a filter.

NOK exchange rates read from Norges Bank
NOK exchange rates in March 2024, which are read from Norges Bank

Zooming in on the chart with percentual change, it looks like the picture below. We see that NOK started the month by strengthening against several currencies, but it ended March by weakening against all currencies in the report except SEK.

The development of NOK exchange rates in March 2024
The development of NOK exchange rates in March 2024

From the table above, we see some notable changes to the NOK exchange rates in March 2024, for example:

  • Weakening against Australian dollar (AUD) by 2.3%
  • Weakening against Canadian dollar (CAD) by 1.9%
  • Weakening against Euro (EUR) by 2.1%
  • Weakening against US dollar (USD) by 2.1%
  • Strengthening against Swedish krona (SEK) by 0.7%

Q1 2024 overview

Zooming in on the table from the picture above, we can see the total development for Q1 2024. In Q1 2024, NOK weakened against all currencies in the report except JPY.

The development of NOK exchange rates in Q1 2024
The development of NOK exchange rates in Q1 2024

Some notable changes to the NOK exchange rates in Q1 2024 are:

  • Weakening against EUR by 3.6%
  • Weakening against Pound sterling (GBP) by 4.6%
  • Weakening against USD by 4.9%
  • Weakening against SEK by 0.4%
  • Strengthening against Japanese yen (JPY) by 1.4%

Bond yields

We also review the bond yields to explore possible reasons to the changes in the NOK exchange rates. From the picture below, we see that in March (the MTD value), all bond yields decreased. This is in contrast to the overall development in 2024, and year-to-date (YTD) the bond yields have still mostly increased.

Summary view of NOK exchange rates and bond yields
Summary view of NOK exchange rates and bond yields

For example, the 5 years yield decreased by 27 bps in March to 3.49%. So far in 2024, however, it has still increased by 26 bps. Compared to 1 year ago, the 5 years yield has increased even more – by 61 bps.

With regards to the bond spreads, that is the difference between bonds with longer duration and bonds with shorter duration, there have been no significant changes neither in March nor in 2024. All bonds with duration from 3 years to 10 years are within the range from 3.49% to 3.64%, so they are close and have seen similar movements so far in 2024.

Summary

In March, NOK weakened against many large currencies like EUR, GBP and USD. It weakened by 2.1% against EUR and USD and by 1.9% against GBP. In the time period of one month, this is not a dramatic change but it is still significant. The development in March is aligned with the overall development in 2024 where NOK has weakened against many currencies. For example, NOK has weakened against USD by 4.9% and against GBP by 4.6%. Meanwhile, it has strengthened against JPY by 1.4% and it is developing similarly to SEK – it has just weakened by 0.4% against SEK.

With regards to the NOK bond yields, they mostly decreased in March. This is in contrast to the overall development in 2024. For example, the 5 years yield decreased by 27 bps in March to reach 3.49% but so far in 2024 it has increased by 26 bps. In addition, compared to 1 year ago, it is 61 bps higher now.

More blog posts

On the development of SWESTR in May 2024

We analyse the development of the SWESTR in May 2024. We use a Power BI report and also review the...

On the development of the SEK exchange rates & bond yields in May 2024

We analyse the development of the SEK exchange rates & bond yields in May 2024. We use a Power BI...

On the development of the SEK exchange rates & bond yields in April 2024

We analyse the development of the SEK exchange rates & bond yields in April 2024. We use a Power BI...

On the development of the NOK exchange rates & bond yields in March and Q1 2024

We analyse the development of the NOK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of SWESTR in March and Q1 2024

We analyse the development of the SWESTR in March and Q1 2024. We use a Power BI report and also...

On the development of the SEK exchange rates & bond yields in March and Q1 2024

We analyse the development of the SEK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of the SWESTR in February 2024

We analyse the development of the SWESTR in February 2024. We use a Power BI report and also analyse...

On the development of the NOK exchange rates & bond yields in February 2024

In this blog post, we will analyse the development of the NOK exchange rates in February 2024. We...

On the development of the SEK exchange rates & bond yields in February 2024

We analyse the development of the SEK exchange rates and bond yields in February 2024. We use a...

On the development of the NOK exchange rates & bond yields in March and Q1 2024 Read More »

NOK exchange rates and bond yields

On the development of SWESTR in March and Q1 2024

Blog

On the development of SWESTR in March and Q1 2024

We analyse the development of the Swedish krona Short-Term Rate (SWESTR) in March and Q1 2024. The SWESTR is a reference rate that can be used for setting rates between banks, and it is based on transactions happening in the financial market. We do the analysis with support from a Power BI report, which we have developed and which is available in our Portfolio. For more information on the SWESTR, please see our previous blog post or the Swedish central bank’s website.

March 2024 overview

We filter the Power BI report to only show data before the 1st of April 2024. We then see in the picture below an overview of the SWESTR development. As an example, we see that March and Q1 2024 ended with the SWESTR at 3.895%. From our blog post on the February development, we notice that this is the same as February, which also ended at 3.895%. The SWESTR has increased by 1.005% points compared to one year ago.

Summary view of the development of SWESTR since its launch
Summary view of the development of SWESTR since its launch

The chart in the upper-left corner presents averages calculated over 1 to 6 months. We see that all averages are slightly below 4%, just like we concluded in the February blog post.

SWESTR trend

In the bottom left chart, in the picture above, we see that the rate with which the SWESTR increases, has slowed down. At the end of Q1 2024, the SWESTR was at 3.9%, and it was unchanged compared to the end of Q4 2023.

To further review the trend over time, we zoom in on the development per month. We then see that 6 months in a row have ended at 3.9%. The policy rate was increased from 3.75% to 4.00% from the 27th of September 2023. After that increase in September, there has been no change to the policy rate so the SWESTR is aligned in that sense. However, it is 10 bps lower at approximately 3.90%.

The monthly development of SWESTR over a longer time
The monthly development of SWESTR over a longer time

Number of transactions and SWESTR volume

We also review the number of transactions and the SWESTR volume in monetary terms. First, we note from the summary picture above, that Q1 2024 had on average 132 transactions happening per day. That was an increase from 80 in Q1 2023 – a 64% increase. The average transaction volume per day decreased from 61.72 BSEK in Q1 2023 to 53.06 BSEK – a 14% decrease and approximately 8.7 BSEK lower volume per day. That is a significant decrease in volume.

In the chart below, we zoom in on the development of daily number of transactions and daily average volume per month. We see that there is a clear trend where the number of transactions per day is increasing, and there were on average 136 transactions per day in March 2024. Ignoring the first months after the launch, the volume goes up and down between approximately 50 BSEK and 65 BSEK per day. It can be concluded that there are more, but smaller, transactions happening per day now compared to before.

Daily average number of transactions and daily average transaction volume since the launch of SWESTR
Daily average number of transactions and daily average transaction volume since the launch of SWESTR

Summary

The SWESTR has remained flat for 6 consecutive months around 3.9%. There are more and more transactions happening each day with the SWESTR – in March on average 136 per day, which is an increase by 61% compared to March last year. At the same time, the average daily volume was 59.2 BSEK in March, which is a decrease by 4% compared to March last year.

More blog posts

On the development of SWESTR in May 2024

We analyse the development of the SWESTR in May 2024. We use a Power BI report and also review the...

On the development of the SEK exchange rates & bond yields in May 2024

We analyse the development of the SEK exchange rates & bond yields in May 2024. We use a Power BI...

On the development of the SEK exchange rates & bond yields in April 2024

We analyse the development of the SEK exchange rates & bond yields in April 2024. We use a Power BI...

On the development of the NOK exchange rates & bond yields in March and Q1 2024

We analyse the development of the NOK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of SWESTR in March and Q1 2024

We analyse the development of the SWESTR in March and Q1 2024. We use a Power BI report and also...

On the development of the SEK exchange rates & bond yields in March and Q1 2024

We analyse the development of the SEK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of the SWESTR in February 2024

We analyse the development of the SWESTR in February 2024. We use a Power BI report and also analyse...

On the development of the NOK exchange rates & bond yields in February 2024

In this blog post, we will analyse the development of the NOK exchange rates in February 2024. We...

On the development of the SEK exchange rates & bond yields in February 2024

We analyse the development of the SEK exchange rates and bond yields in February 2024. We use a...

On the development of SWESTR in March and Q1 2024 Read More »

NOK exchange rates and bond yields

On the development of the SEK exchange rates & bond yields in March and Q1 2024

Blog

On the development of the SEK exchange rates & bond yields in March and Q1 2024

We analyse the development of the Swedish krona (SEK) exchange rates & bond yields in March and Q1 2024. We do the analysis by using a Power BI report, which is available in our Portfolio.

March 2024 overview

We filter the Power BI report so that only data up until and including 31st of March 2024 is included. We then start by going to the page with the exchange rates development, where we see that SEK weakened in March against all the currencies in the report. It weakened the most – by 3.0% – against CAD, GBP and USD and by 2.9% against EUR and DKK. In the period of just one month, this is a significant development of the exchange rates.

The development of SEK exchange rates in Q1 2024
The development of SEK exchange rates in Q1 2024

We then click on March in the table and the page is filtered with March as a filter. The chart below shows the percentual development in March 2024 only.

The development of SEK exchange rates in March 2024
The development of SEK exchange rates in March 2024

We see on the summary page that the bond yields have increased significantly year-to-date (YTD) for most of the bonds in the report. However, in March there was a clear decrease in most bond yields. For example, the SEK 10 years yield decreased by 20 bps in March and GBP 10 years yield decreased by 16 bps. The USD yields increased in March – 5 years increased by 6 bps and 10 years by 2 bps.

Summary of SEK exchange rates and bond yields
Summary of SEK exchange rates and bond yields

Q1 2024 overview

For the first quarter, the SEK strengthened against several currencies to begin with, up until March. We also described this in our post on the February 2024 SEK exchange rates development. In March, however, SEK weakened and this is largely the trend YTD as well. So far in 2024, the SEK development is within the range -2% to 5%. Some notable SEK exchange rates changes so far in 2024 are:

  • Strengthening against JPY by 1.6%
  • Strengthening against CHF by 1.6%
  • Weakening against EUR by 3.3%
  • Weakening against GBP by 4.7%
  • Weakening against USD by 4.7%

The bond yields have increased during the quarter for all bonds in the report. For example, SEK 2 years yield increased by 41 bps and the 10 years by 22 bps. The GBP 10 years increased by 30 bps and USD 10 years by 27 bps.

With regards to the bond spreads, that is, the difference between short-term bonds and long-term bonds, decreased in the quarter for SEK. The 2s10s bond spread decreased by 19 bps to -0.38%, meaning that the 2 years yield increased more (+41 bps) than the 10 years yield (+22 bps).

Summary

In March 2024, the SEK weakened against several large currencies. For example, it weakened by 3.0% against both GBP and USD and by 2.9% against EUR. Bond yields decreased in March for all the bonds in the report except for the USD and JPY. For example, the 10 years SEK yield decreased by 20 bps in March.

While SEK started the year strengthening against several currencies, it has now weakened against large currencies like EUR (3.3%), GBP (4.7%) and USD (4.7%) and strengthened against for example JPY and CHF (1.6%).

More blog posts

On the development of SWESTR in May 2024

We analyse the development of the SWESTR in May 2024. We use a Power BI report and also review the...

On the development of the SEK exchange rates & bond yields in May 2024

We analyse the development of the SEK exchange rates & bond yields in May 2024. We use a Power BI...

On the development of the SEK exchange rates & bond yields in April 2024

We analyse the development of the SEK exchange rates & bond yields in April 2024. We use a Power BI...

On the development of the NOK exchange rates & bond yields in March and Q1 2024

We analyse the development of the NOK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of SWESTR in March and Q1 2024

We analyse the development of the SWESTR in March and Q1 2024. We use a Power BI report and also...

On the development of the SEK exchange rates & bond yields in March and Q1 2024

We analyse the development of the SEK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of the SWESTR in February 2024

We analyse the development of the SWESTR in February 2024. We use a Power BI report and also analyse...

On the development of the NOK exchange rates & bond yields in February 2024

In this blog post, we will analyse the development of the NOK exchange rates in February 2024. We...

On the development of the SEK exchange rates & bond yields in February 2024

We analyse the development of the SEK exchange rates and bond yields in February 2024. We use a...

On the development of the SEK exchange rates & bond yields in March and Q1 2024 Read More »

NOK exchange rates and bond yields

On the development of the SWESTR in February 2024

Blog

On the development of the SWESTR in February 2024

We analyse the development of the Swedish krona Short-Term Rate (SWESTR) in February 2024. The SWESTR is a reference rate that can be used for setting rates between bank, and it is based on transactions happening in the financial market. We do the analysis by using a Power BI report, which is available in our Portfolio. For more information on the SWESTR, please see our previous blog post or the Swedish central bank’s website.

Overview

We start by filtering the Power BI report so that it only considers data before the 1st of March 2024, which is an option only accessible to us as report creators. We then see in the page below that the last published SWESTR is 3.895%, which was published at the 29th of February. That is an increase of 99.8 bps compared to one year ago.

Overview of the SWESTR development
Overview of the SWESTR development presented in a Power BI report

The chart in the upper-left corner presents averages calculated over 1 to 6 months. We see that all averages are slightly below 4%. We also see clearly that the SWESTR has increased steadily since its launch in 2021.

The SWESTR trend

In the bottom-left chart above, we see that the rate with which the SWESTR increases, has slowed down. Since Q4 2022, the increases measured at the end of each quarter, have been:

  • Q4 2022 to Q1 2023: 0.5%
  • Q1 2023 to Q2 2023: 0.5%
  • Q2 2023 to Q3 2023: 0.3%
  • Q3 2023 to Q4 2023: 0.2%
  • Q4 2023 to 2024 YTD: 0.0%

To further review the trend over time, we can zoom in on the development per month. We then see that 5 months in a row have ended at 3.9%.

SWESTR's monthly development
SWESTR’s monthly development since the launch in 2021. The 1 week average at the end of each month is presented

Number of transactions and SWESTR volume

Finally, we review the number of transactions and the SWESTR volume in monetary terms. First, we note in the overview picture above, that so far in Q1, there are on average 130 SWESTR transactions happening per day. That is an increase by 62% compared to the same quarter last year. On the other hand, we see that the average volume per transaction is 0.4 billion SEK, which is a decrease by 50%. So, there are more transactions happening but the transactions are smaller on average.

In the chart below, we zoom in on the transaction and volume development per month. There is a clear trend where the average number of transactions per day is increasing.

Number of transactions and volume
Number of transactions and volume

For February specifically, the average volume per day was 51.5 billion SEK – a decrease by 26% year-over-year. Similarly, the number of transactions in February was at 131, which was an increase by 65% year-over-year. Compared to January, the daily number of transactions was approximately the same with just a 1% increase. The volume increased from 49.0 to 51.5 billion SEK – a 5% increase.

Summary

The SWESTR has remained flat for 5 consecutive months around 3.9%. There are more and more transactions happening each day with the SWESTR, as evidenced by the daily number of transactions clearly trending upwards. In February, there were on average 131 transactions per day, which is a 65% increase compared to February last year. At the same time, the average daily volume was 51.5 billion SEK, which is a decrease by 26% compared to February last year.

More blog posts

On the development of SWESTR in May 2024

We analyse the development of the SWESTR in May 2024. We use a Power BI report and also review the...

On the development of the SEK exchange rates & bond yields in May 2024

We analyse the development of the SEK exchange rates & bond yields in May 2024. We use a Power BI...

On the development of the SEK exchange rates & bond yields in April 2024

We analyse the development of the SEK exchange rates & bond yields in April 2024. We use a Power BI...

On the development of the NOK exchange rates & bond yields in March and Q1 2024

We analyse the development of the NOK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of SWESTR in March and Q1 2024

We analyse the development of the SWESTR in March and Q1 2024. We use a Power BI report and also...

On the development of the SEK exchange rates & bond yields in March and Q1 2024

We analyse the development of the SEK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of the SWESTR in February 2024

We analyse the development of the SWESTR in February 2024. We use a Power BI report and also analyse...

On the development of the NOK exchange rates & bond yields in February 2024

In this blog post, we will analyse the development of the NOK exchange rates in February 2024. We...

On the development of the SEK exchange rates & bond yields in February 2024

We analyse the development of the SEK exchange rates and bond yields in February 2024. We use a...

On the development of the SWESTR in February 2024 Read More »

NOK exchange rates and bond yields

On the development of the NOK exchange rates & bond yields in February 2024

Blog

On the development of the NOK exchange rates & bond yields in February 2024

We analyse the development of the Norwegian krone (NOK) exchange rates and bond yields in February 2024. We do so by using a Power BI report that is available in our Portfolio. The source of all data is the Norwegian central bank – Norges Bank.

February 2024 overview

We start by going to this page and expanding the table so that the development in each month is visible. Then we click on February and consequently the whole page will be updated with February as a filter. This is a convenient way to filter without having explicit filters visually present in the report, which shows how dynamic Power BI is.

The development of the NOK exchange rates in February 2024
The development of the NOK exchange rates in February 2024

We then see that, in February, NOK strengthened against two currencies – Canadian dollar (CAD) and Japanese yen (JPY). Similarly to what we reported in our blog post on the January development, there were no dramatic changes of the NOK exchange rates in February. In February, all movements were in the range from -1% to 2%. It can be noted here that + means that NOK weakened, and – means that NOK strengthened. For example, if the EUR-NOK exchange rate goes from 10 to 11, that +1 change is a weakening of the NOK.

We note that NOK weakened the most – by 2.2% – against Swedish krona (SEK). We noted in our blog post on the SEK’s February development that SEK strengthened against many large currencies like CHF, EUR, GBP and USD. However, NOK weakened in February by 0.7% against GBP and by 1.0% against USD.

Year-to-date (YTD) in 2024, NOK has strengthened against Australian dollar (AUD) by 1.6% and against JPY by 3.0%. All movements YTD are in the range from -3% to 3%.

We then look at a summary page of the exchange rates in conjunction with NOK bond yields. First, we filter the page so that it only considers data before 1st of March 2024. We then see that there were large increases in the bond yields in February. For example, the 3 years bond yield increased by 43 bps to 3.91% and the 10 years yield increased by 32 bps to 3.80%. On the other hand, the bonds with short duration increased by smaller amounts. For example, the 6 months yield only increased by 4 bps to 4.51%, which is close to Norway’s current policy rate at 4.50%.

NOK exchange rates and bond yields
Summary view of the NOK exchange rates and bond yields with data from Norges Bank

Year-to-date, the bond yields have increased significantly, and some examples are:

  • 3 years: +59 bps to 3.91%
  • 5 years: +53 bps to 3.76%
  • 10 years: +55 bps to 3.80%

Finally, we review the bond spreads, which are the differences in yields between shorter-term bonds and longer-term bonds. For example, a common financial metric is to measure the difference in yield between a 5 years bond and a 10 years bond. We see that the 3s10s bond spread decreased by 12 bps to -0.10%, since the 3 years yield increased by 43 bps but the 10 years yield only increased by 32 bps.

Summary

In February 2024, there were no dramatic changes of the NOK exchange rates against major currencies like GBP, EUR, JPY and USD. The NOK weakened by 2.2% against SEK and by 1.1% against EUR. Meanwhile, the NOK strengthened by 1.1% against JPY.

With regards to the bond yields, there were large increases in the NOK bond yields in February. The bonds with short duration (3 – 12 months) barely moved but the ones with longer duration increased more, for example the 10 years yield increased by 32 bps in February.

More blog posts

On the development of SWESTR in May 2024

We analyse the development of the SWESTR in May 2024. We use a Power BI report and also review the...

On the development of the SEK exchange rates & bond yields in May 2024

We analyse the development of the SEK exchange rates & bond yields in May 2024. We use a Power BI...

On the development of the SEK exchange rates & bond yields in April 2024

We analyse the development of the SEK exchange rates & bond yields in April 2024. We use a Power BI...

On the development of the NOK exchange rates & bond yields in March and Q1 2024

We analyse the development of the NOK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of SWESTR in March and Q1 2024

We analyse the development of the SWESTR in March and Q1 2024. We use a Power BI report and also...

On the development of the SEK exchange rates & bond yields in March and Q1 2024

We analyse the development of the SEK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of the SWESTR in February 2024

We analyse the development of the SWESTR in February 2024. We use a Power BI report and also analyse...

On the development of the NOK exchange rates & bond yields in February 2024

In this blog post, we will analyse the development of the NOK exchange rates in February 2024. We...

On the development of the SEK exchange rates & bond yields in February 2024

We analyse the development of the SEK exchange rates and bond yields in February 2024. We use a...

On the development of the NOK exchange rates & bond yields in February 2024 Read More »

On the development of the SEK exchange rates & bond yields in February 2024

Blog

On the development of the SEK exchange rates & bond yields in February 2024

We analyse the development of the SEK exchange rates and bond yields in February 2024. We do so by using a Power BI report that is available in our Portfolio.

February 2024 overview

We start by going to this page and changing the Date filter in the filter menu. This is only accessible to us as the report creators. We do the filtering because otherwise the report will think that we are in March, hence the month-to-date (MTD) values will be incorrect as an example. This page is a summary view of the SEK exchange rates & bond yields, and comparisons against large currencies like GBP, EUR and USD can be seen.

The development of the SEK exhange rates and bond yields in February 2024

The filtering in Power BI looks like below.

Filter menu in Power BI

We then see that in February, the SEK strengthened against all the currencies in the report. It strengthened the most – by 3% – against Swiss franc (CHF) and Japanese yen (JPY). In our blog post about the January 2024 SEK development, we noticed that SEK only strengthened against one currency – the JPY.

In general, there were no dramatic changes in February, just like in January. The SEK movements were in the range from -1% to -3%. It can be noted here that + means that SEK weakened, and – means that SEK strengthened. For example, if the EUR-SEK exchange rate goes from 10 to 11, that +1 change is a weakening of the SEK.

When looking at the quarter-to-date (QTD) and year-to-date (YTD) values, which are the same in the first quarter, we see that the SEK movements are within the range -4% (strengthening) to +2% (weakening), and again it has strengthened the most against JPY and CHF. It has weakened the most against GBP and USD – by 2%.

We also note that there were large changes to the bond yields in February, not only to the SEK bond yields. We see that the GBP 5 years and USD 5 years bond yields increased by 34 respective 43 bps. The SEK 5 years yield increased by approximately the same value – by 39 bps.

For SEK, we read several different bond yields, and we notice something interesting for the 2 years and 10 years yields development in February. The SEK 2 years yield increased by 42 bps, but the 10 years yield only increased by 28 bps. That is a 14 bps difference. Hence, the so called “bond spread” between the 2 years and 10 years yields, decreased by 14 bps in February.

To get further insight on the bond yields, we go to this page and change the Year filter to range from 2023 to 2024. We see that there is a clear increase in all the SEK bond yields in February 2024.

SEK exchange rates and bond yields
SEK exchange rates and bond yields in comparison to USD bond yields

Finally, we go to this page and click on February in the table. By doing so, the Power BI page will be updated with February as a filter. We then see the more exact numbers of the SEK strengthening in February.

The development of the SEK exchange rates in February 2024
The development of the SEK exchange rates in February 2024

For example, some highlighted changes are the following SEK movements:

  • Strengthening against JPY by 3.2%
  • Strengthening against CHF by 3.1%
  • Strengthening against CAD by 2.2%
  • Strengthening against NOK by 2.1%

Summary

In February 2024, there were no dramatic changes of the SEK exchange rates compared to major currencies like GBP, EUR and USD. The SEK strengthened against many of the large currencies, for example it strengthened by 3.2% against JPY and 3.1% vs CHF.

With regards to bond yields, there were larger changes both for the SEK yields and other bond yields like USD and GBP. For example, the SEK 5 years yield increased by 39 bps, which can be compared to +43 bps for USD and +34 bps for GBP.

More blog posts

On the development of SWESTR in May 2024

We analyse the development of the SWESTR in May 2024. We use a Power BI report and also review the...

On the development of the SEK exchange rates & bond yields in May 2024

We analyse the development of the SEK exchange rates & bond yields in May 2024. We use a Power BI...

On the development of the SEK exchange rates & bond yields in April 2024

We analyse the development of the SEK exchange rates & bond yields in April 2024. We use a Power BI...

On the development of the NOK exchange rates & bond yields in March and Q1 2024

We analyse the development of the NOK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of SWESTR in March and Q1 2024

We analyse the development of the SWESTR in March and Q1 2024. We use a Power BI report and also...

On the development of the SEK exchange rates & bond yields in March and Q1 2024

We analyse the development of the SEK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of the SWESTR in February 2024

We analyse the development of the SWESTR in February 2024. We use a Power BI report and also analyse...

On the development of the NOK exchange rates & bond yields in February 2024

In this blog post, we will analyse the development of the NOK exchange rates in February 2024. We...

On the development of the SEK exchange rates & bond yields in February 2024

We analyse the development of the SEK exchange rates and bond yields in February 2024. We use a...

On the development of the SEK exchange rates & bond yields in February 2024 Read More »

How to create a hierarchy in Power BI

Blog

How to create a hierarchy in Power BI

In this blog post, we will learn how to create a hierachy in Power BI. This can be useful for example when analysing sales within different categories. The sales can then be measured and analysed for all the categories in an efficient way.

Another example, which we will go through, is how to create a date hierarchy in Power BI. This is convenient for the user because it is then easy to analyse performance per Year, Quarter, Month and Day and easily switch between these perspectives.

How to create the hierarchy

Just like in a previous post, where we discussed the streaming of GA4 data to Power BI, we can continue the example of the e-commerce business. The e-commerce business measures sales at various levels. The levels and their possible values are:

  • Level 1 – Clothing, Watches, Accessories
  • Level 2 – Men, Women
  • Level 3 – Summer, Winter

Even this relatively simple example leads to several combinations that need to be analysed. A hierarchy will solve this efficiently for us, and we do not have to create specific calculations in order to measure for example “Clothing, Women, Summer” performance.

To start with, we go to the Home tab in Power BI, and then we right-click on the Level 1 column where we select “Create hierarchy”.

Hierarchy in Power BI
Right-click in Power BI and select Create hierarchy

We then rename the hierarchy to “Product hierarchy”, right-click on Level 2 and add it to Product hierarchy. We also do the same for the Level 3 column.

Power BI hierarchy
Right-click on the column name and select Add to hierarchy

By using a matrix visualisation, we then verify our hierarchy. We add the hierarchy and also the Sales column to the matrix visualisation. By expanding the matrix, we can see in the pictures below what the sales look like for each level.

Visualisation of sales data – Level 1 of our hierarchy
Power BI hierarchy
Visualisation of sales data – Level 2 of our hierarchy
Power BI hierarchy
Visualisation of sales data – Level 3 of our hierarchy

How to create a date hierarchy

A common use case of hierarchies is to create one that helps you break down your KPIs in different time periods, a so called date hierarchy. Typically, we will have a Calendar table in our Power BI model. We can then create our date hierarchy by the following steps.

First, we decide that we want to replicate this structure in Power BI:

  • Year
    • Quarter
      • Month
        • Day

To start with, we notice that all these four columns exist in our Calendar table. We then right-click on Year, as that is our highest level, and select “Create hierarchy”.

Date hierarchy in Power BI
Right-click on Year and select Create hierarchy

We also right-click on the hierarchy and name it “Date hierarchy”. Finally, we add the Quarter, Month and Day columns to our newly created Date hierarchy. We do so by using the same method that we used above, that is, to right-click and select Add to hierarchy.

Again, we verify our hierarchy by using a matrix visualisation. We see that we now have a convenient way of switching between Year, Quarter, Month and Day. We also notice that the sorting of the Months is in alphabetic order, which is not optimal. There are ways around that, but that is for another blog post – stay tuned.

Date hierarchy in Power BI
Date hierarchy in Power BI

Summary

We learnt how to create a hierarchy in Power BI and discussed two examples where this can be useful. A common scenario is to create a Date hierarchy, but it is also useful for other scenarios like the example we discussed, where an e-commerce business wants to analyse their sales by different categories.

More blog posts

On the development of SWESTR in May 2024

We analyse the development of the SWESTR in May 2024. We use a Power BI report and also review the...

On the development of the SEK exchange rates & bond yields in May 2024

We analyse the development of the SEK exchange rates & bond yields in May 2024. We use a Power BI...

On the development of the SEK exchange rates & bond yields in April 2024

We analyse the development of the SEK exchange rates & bond yields in April 2024. We use a Power BI...

On the development of the NOK exchange rates & bond yields in March and Q1 2024

We analyse the development of the NOK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of SWESTR in March and Q1 2024

We analyse the development of the SWESTR in March and Q1 2024. We use a Power BI report and also...

On the development of the SEK exchange rates & bond yields in March and Q1 2024

We analyse the development of the SEK exchange rates & bond yields in March and Q1 2024. We use a...

On the development of the SWESTR in February 2024

We analyse the development of the SWESTR in February 2024. We use a Power BI report and also analyse...

On the development of the NOK exchange rates & bond yields in February 2024

In this blog post, we will analyse the development of the NOK exchange rates in February 2024. We...

On the development of the SEK exchange rates & bond yields in February 2024

We analyse the development of the SEK exchange rates and bond yields in February 2024. We use a...

How to create a hierarchy in Power BI Read More »