Hi Guys, Putting together a spreadsheet for my stocks. Using a template which can be found here for anyone interested. (Not my template) Though the formatting for the sheet is in usd, I need some to be in GBP. With the formatting of share price in the uk being different from US stocks, when the p…

Assuming you have a symbol in cell A2, then Get exchange rate using =GOOGLEFINANCE(“CURRENCY:USDGBP”) and store in some cell, for example C1 Get currency for your stock using =GOOGLEFINANCE(A2, "currency") and store it in B2 And then =GOOGLEFINANCE(A2)*IF(B2="USD", $C$1, IF(B2="GBX", 0.01, 1)) in …

Google Spreadsheets

General Chat 💬

bitflip Split this topic 29 September 2022 21:50 2

8 posts were merged into an existing topic: How do you track your stocks and shares?!

Topic		Replies	Views
Little feature request Ideas 💡	3	417	17 February 2021
How does Freetrade convert $ to £? Need for Google Sheets Tracker Help 👋	7	1373	21 July 2020
“Your investment” info for U.S stocks Ideas 💡	5	719	17 November 2020
Buying American Shares Ideas 💡	7	808	2 April 2021
US stocks displayed in $ and £ Ideas 💡	0	58	17 July 2024

Google Spreadsheets

Related topics