Skip to main content
Web Applications

Return to Question

Bumped by Community user
deleted 11 characters in body
Source Link
serenesat
serenesat
  • 10k
  • 30
  • 33
  • 50

This formula returns the daily stock prices of A1 in the last two years:

=GOOGLEFINANCE(A1,"Price",today()-(365*2),today(),"DAILY")

This formula returns the daily conversion rate from USD to EUR:

=GOOGLEFINANCE("Currency:USDEUR", "price", today()-(365*2),today())

I would like to put the two formulas together so that the historical stock prices are automatically given in EUR and not in USD. Is there any way to put the two formulas into one? Maybe with the help of SQL?

Thanks!

This formula returns the daily stock prices of A1 in the last two years:

=GOOGLEFINANCE(A1,"Price",today()-(365*2),today(),"DAILY")

This formula returns the daily conversion rate from USD to EUR:

=GOOGLEFINANCE("Currency:USDEUR", "price", today()-(365*2),today())

I would like to put the two formulas together so that the historical stock prices are automatically given in EUR and not in USD. Is there any way to put the two formulas into one? Maybe with the help of SQL?

Thanks!

This formula returns the daily stock prices of A1 in the last two years:

=GOOGLEFINANCE(A1,"Price",today()-(365*2),today(),"DAILY")

This formula returns the daily conversion rate from USD to EUR:

=GOOGLEFINANCE("Currency:USDEUR", "price", today()-(365*2),today())

I would like to put the two formulas together so that the historical stock prices are automatically given in EUR and not in USD. Is there any way to put the two formulas into one? Maybe with the help of SQL?

Source Link
Simone Romeo
Simone Romeo
  • 11
  • 1

Get historical stock price in another currency

This formula returns the daily stock prices of A1 in the last two years:

=GOOGLEFINANCE(A1,"Price",today()-(365*2),today(),"DAILY")

This formula returns the daily conversion rate from USD to EUR:

=GOOGLEFINANCE("Currency:USDEUR", "price", today()-(365*2),today())

I would like to put the two formulas together so that the historical stock prices are automatically given in EUR and not in USD. Is there any way to put the two formulas into one? Maybe with the help of SQL?

Thanks!