🍪 Privacy & Transparency

We and our partners use cookies to Store and/or access information on a device. We and our partners use data for Personalised ads and content, ad and content measurement, audience insights and product development. An example of data being processed may be a unique identifier stored in a cookie. Some of our partners may process your data as a part of their legitimate business interest without asking for consent. To view the purposes they believe they have legitimate interest for, or to object to this data processing use the vendor list link below. The consent submitted will only be used for data processing originating from this website. If you would like to change your settings or withdraw consent at any time, the link to do so is in our privacy policy accessible from our home page..

Vendor List | Privacy Policy
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 - Conditions using IF THEN ELSE formula

The basic structure of the IF THEN ELSE formula in Google sheets is an IF formula with parameters, it looks like the following: =IF(logical_expression; »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on Google sheets 17 November 2022

Google sheets - How to create a drop-down list in a cell

You can easily create in-cell drop-downs in Google sheets using the "Data validation" menu point. It can be found under: * Data * Data Validation Located right here »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on Google sheets 09 November 2022

Google sheets - What is the $ sign (Dollar-sign) for when referencing a cell?

You can reference a cell in Google Sheets by using its location, for example A1, B4 or C2. The location is the combination of the Column »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on Google sheets 23 October 2022

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
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 © 2023 Privacy policy