the daily rate you can store into a qvd
at the load script from courses add
today() as RateDate
so you have the date the rate belongs.
Also store the daily rates into daily qvds.
In your data model load all rate qvds and link rate date to datas.
For former rates you have to create datas.