How to get the price of a Stock in Google sheets
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 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 get the price of a currency (exchange rate)
What you are looking for is likely the following: =GOOGLEFINANCE("CURRENCY:<firstCurrency><secondCurrency>") You simply supply the two currencies you »
Google sheets - How to make a sparkline for a stock using Google Finance
Today I decided to add some sparklines to my personal spreadsheet that I use to keep track of my stocks. These are small graphs that are »
C# - How to call the Yahoo Finance API in .Net
Yahoo has one of the best free financial APIs out there and in this post you will see an example of how to call it. Yahoo »
Getting current price for a stock in Google sheets - updated 2022
Disclaimer: The stocks in this post have been picked randomly. I currently own none of the stocks in this post (as of 2022-04-11), this post is »