All posts tagged with "Google sheets"

You can easily fetch tables from websites in your Google sheets. To do this you can use the IMPORTTABLE function, which has the following signature: IMPORTHTML( »

You can easily get a stock price in Google sheets using the GOOGLFINANCE function. A simple example would be if you want the current price of »

There is no straightforward formula to get the percentage change for a stock X days back in time. However using the "price" API from Google finance »

You can easily reference a cell from another sheet in the same file using the following formula: =''! If we have two »

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 »

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:") You simply supply the two currencies you want the exchange rate between, for example: =GOOGLEFINANCE( »

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 »