Besides tracking my portfolio on StocksCafe, I also maintain my own Excel spreadsheet to track my investment portfolio and personal finance matters. I usually copy and paste the closing price from either Yahoo Finance or StocksCafe manually, but I recently found a method to automate this process. It may require a bit of time to set up, but it saves me the subsequent time and effort to update over 10 stocks that I own.

I was inspired by the video below which works for people who are using Windows.

If you’re a Mac user like me, fret not, because I found a way to achieve the same result.

Let’s say we are interested in getting the stock price of DBS. We can use Yahoo Finance to arrive at the page below.