I have timeseries for a bunch of currencies. For example, USD_NOK, EUR_USD, EUR_NOK, EUR_SEK and so forth. About 75 of them going back about 20 years in Pandas.
My goal is to isolate each currency separately. In other words I want to get a table with the movement of each currency individually. For example, how has NOK fluctuated during these 20 years?
I can see the NOK according to USD have gone up and down. But in the same time, NOK have fluctuated with EUR. And EUR have fluctuated with USD. If for example during a particular month EUR and USD has been fairly stable, and NOK have increased in comparison to USD but not according to EUR, I now that it is NOK that has changed.
Obviously I am not going to get a perfect "value" for each currency. But is there some method I can look into to isolate the effect of each column.