Home Tags Privacy About

All posts tagged with "Google sheets"

Google sheets is an online editor for spreadsheets and part of Google Drive. Together with Google finance this is a great tool for finance.

Page 1 of 2 Older Posts →

Google sheets - How to import a table from a website

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( »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on Google sheets 29 May 2022

Google sheets - How to get the price of a Stock using GOOGLEFINANCE function - Updated 2022

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 »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on Google sheets 07 May 2022

Google sheets - How to get the percentage change for a stock x days back

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 »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on Google sheets 02 May 2022

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: =''! If we have two »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on Google sheets 12 April 2022

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 »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on Google sheets 11 April 2022

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 »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on Google sheets 11 April 2022

Google sheets - How to get the price of a currency (exchange rate)

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( »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on Google sheets 10 April 2022

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 »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on Google sheets 28 December 2021

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 »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on Google sheets 26 December 2021

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 long-term investor you might »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on Google sheets 05 December 2021
Page 1 of 2 Older Posts →
Rss
Twitter
LinkedIn
profile for Peter Rasmussen at Stack Overflow, Q&A for professional and enthusiast programmers
Peter Daugaard Rasmussen - developer, Consultant, Blogger © 2022 Privacy policy