Forum Discussion

WOODBR_1's avatar
WOODBR_1
Copper Contributor
Apr 23, 2021

Pulling Historical Exchange Rates

Hi, Excel has the function to bring in Exchange Rates "live" with a circa 15 minutes delay, which works fine; however, does anybody know how to cause Excel to being in exchange rates by dates, so th...
excel
OmerAyan's avatar
OmerAyan
Copper Contributor
Jan 08, 2024

WOODBR_1 Excellent knowledge, thank you Sergei, you have saved lots of time

ingstephenmallia's avatar
ingstephenmallia
Copper Contributor
Mar 20, 2024

OmerAyan , SergeiBaklan 

I am trying to get USD to EURO for a particular date.

The date is in 'date' format.  Can you help me out, please?

 

Thanks in advance.

  • MarekBernolak's avatar
    MarekBernolak
    Copper Contributor
    Mar 20, 2024

    Hi ingstephenmallia,
    I guess, what you need is to type a date between double quotes, i.e. "19/03/2024" or to reference to a date in another cell.

     

    Best Regards 🙂

     

    • Pamm1708's avatar
      Pamm1708
      Copper Contributor
      Jun 21, 2024

      MarekBernolak is it possible to use the same format and ask it to link to a date in another cell ? I have a download from a credit card account in USD and I need to convert the transactions into GBP

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Jun 25, 2024

        Pamm1708 

        That could be like

        =TAKE( STOCKHISTORY(  "USD/GBP", [@Date] - 10, [@Date], 0,0,1), -1 )*[@Amount]

        Since STOCKHISTORY skips weekends and public holidays and transactions could be at any day, we need to get data for some range and take the latest available.

Resources