Google sheets - How to reference a cell in another sheet
You can easily reference a cell from another sheet in the same file using the following formula: ='<Sheet name>'!<Cell> »
Google sheets - How to get stock price in local currency
In this post I show you how I convert the value of my stocks to local currency. This is DKK for me, but it could be »
Google sheets - How to add a variable to a formula using concatenation
In this post I will use the example of getting currency rates from the Google finance API. For this we will do a conversion between two »
Google sheets - How to get the price of a currency (exchange rate)
What you are looking for is likely the following: =GOOGLEFINANCE("CURRENCY:<firstCurrency><secondCurrency>") You simply supply the two currencies you »
Google sheets - How to get the value of a cell from another tab to use in a formula
Using Google sheets it is quite easy to get a value from another tab and quite harder to get it from a different sheet. Luckily we »
Google sheets - How to link to a cell or another tab
Searching around the web I could not find an easier solution than this. I recently created a sheet with a lot of tabs. In order to »
Google sheets - How to get year-to-date (YTD) change for a stock
Using =GOOGLEFINANCE("HKG:9988","changepct") you can get the price change since open or last open of the exchange. However as more »
Google sheets - How to make a sparkline for a stock using Google Finance
Today I decided to add some sparklines to my personal spreadsheet that I use to keep track of my stocks. These are small graphs that are »
Google sheet - How to freeze/hold/fix/lock a row to the top or first column of the sheet
For some reason I can never remember how to do this, so I decided to write this post about it. Often you want to freeze the »
Google sheets - How to sum all negative or positive numbers in a range
I recently needed to sum all the negative and positive numbers in a range before adding them together. This was to see the total earnings and »