Skip to content

Instantly share code, notes, and snippets.

Maturity Spot_Rate Currency
1 0.010 USD
2 0.012 USD
3 0.014 USD
4 0.016 USD
5 0.018 USD
6 0.020 USD
7 0.022 USD
8 0.024 USD
9 0.026 USD

Calculate forward rate

Formula to calculate forward rate from spot rate

Maturity Spot_Rate Spot_Rate_Shift
1 0.01 0.0
2 0.012 0.01
3 0.014 0.012
4 0.016 0.014
5 0.018 0.016
6 0.02 0.018
7 0.022 0.02
8 0.024 0.022
9 0.026 0.024
# Implementation with PySpark
from pyspark.sql import SparkSession
from pyspark.sql import Window
from pyspark.sql import functions as f
# Define Spark settings
builder = SparkSession.builder.appName("Koalas")
spark = builder.getOrCreate()
# Read in the spot rate data
Maturity Spot_Rate Currency Spot_Rate_Shift Forward_Rate
1 0.01 USD 0.0 0.01
2 0.012 USD 0.01 0.014
3 0.014 USD 0.012 0.018
4 0.016 USD 0.014 0.022
5 0.018 USD 0.016 0.026
6 0.02 USD 0.018 0.03
7 0.022 USD 0.02 0.034
8 0.024 USD 0.022 0.038
9 0.026 USD 0.024 0.042
# Implementation with PySpark
from pyspark.sql import SparkSession
from pyspark.sql import Window
from pyspark.sql import functions as f
# Define Spark settings
builder = SparkSession.builder.appName("Forward_Rate_Calculation")
spark = builder.getOrCreate()
# Read in the spot rate data as csv