So, due to using the Google Finance formula in the expenses tracking sheet, I realise that I didn’t have a formula to track my money movement. I wanted to know if it was going out or coming in. Considering that outgoing money is rather common, the tracking sheet looked more like a sheet for loss rather than a balance sheet that companies would be using.
So, I decided to use conditional formatting by inputting another column to state the movement. Based on the selection, the amount would change in text colour. As much as I would love to use Google Finance to look up the currency exchange rate only once, it is unfortunate that I have yet to find a solution to use the Google Finance to look up only on a particular day since it will be doing it real time.