Google spreadsheet - How to freeze/hold/fix/lock a row to the top or first column of the sheet
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 »
Google spreadsheets - How to sum all negative or positive numbers in a range
So I recently wanted to sum all the negative and positive numbers in a range before adding them together. This was to see the total earnings »
How to get (scrape) stock prices/quotes from websites in Google spreadsheets using ImportXml
It is no secret that I like to spend some time on investing, buying and selling stocks and index funds. I use Google spread sheets in »
Google spreadsheet how to fix/hold value when dragging cells
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 »
Getting current price for a stock in google spreadsheets
It is both easy and possible to get the current price of a stock in Google spreadsheets. You simply use the GOOGLEFINANCE() command with a ticker, »