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 »
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 »
What you are looking for is likely the following:
=GOOGLEFINANCE("CURRENCY:
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 »
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 »
Using =GOOGLEFINANCE("HKG:9988","changepct") you can get the price change since open or last open of the exchange. However as more long-term investor you might »
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 »
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 »
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 »
It is no secret that I like to spend some time on investing, buying and selling stocks and index funds. I use Google sheets in order »
This is for many very common knowledge. However I saw this question recently and thought I would put a post out there with an answer. The »