Forum Discussion

alexx1202's avatar
alexx1202
Copper Contributor
Feb 16, 2025

How to quickly convert column of currency amounts to other currency using historical price data?

Hi I traded crypto spot markets in 2020 and am now in the process of journaling all those trades.   I want to know if via excel I can create something that instantly converts all the amounts of BNB...
excel
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Feb 20, 2025

I'm not sure which column in the BNBUSD_1_Binance sheet shows the exchange rate. In the attached file i've made up an example where column E in sheet BNBUSD_1_Binance is the exchange rate. Sheet2 in my sample file uses Power Query for a suggestion. You can enter data to the blue dynamic tables. Then you can right-click in any cell of the green result table and select refresh to update the results in the green table.

 

  • alexx1202's avatar
    alexx1202
    Copper Contributor
    Feb 20, 2025

    Hi Oliver

     

    Thank you for the file.

     

    However, I can’t seem to get it to do what I want.

     

    I’ve managed to isolate the 2020 minute by minute data I need from the big 400mb file and got it down to 6.7mb and attached it for you.

     

    Also attached is the excel file with all the BNB fees that need converting (some fees aren’t BNB).

     

    Hopefully this helps.

     

    I very much appreciate your efforts.

Resources