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 price is carried in from google finance, it is brought in incorrectly. E.g LON:CRS is 1088p (£10.88) but the spreadsheet assumes US format and price of £1,088. The cells are also formatted to $. Can someone advise on the commands to change the format to £ if the ticker contains “LON” along with altering the decimal point to adjust?
If any one has any nice google sheets for their portfolio and/or DD that they wouldn’t mind sharing a template, it would also be great!