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; »
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 »
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 »
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( »
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 »
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 »
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:
='
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: