Stocks Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/stocks/ Bestselling Excel and Power BI Courses Fri, 24 Mar 2023 08:49:18 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Stocks Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/stocks/ 32 32 How to Use Excel’s STOCKHISTORY Function https://www.xelplus.com/excel-stockhistory-function/ Thu, 28 Jan 2021 10:00:00 +0000 https://www.xelplus.com/?p=8967 The StockHistory Function in Excel allows you to easily pull historical stock data in Excel with a single formula. You can get daily, weekly or monthly data. Find out how to use this together with sparklines to visualize the trend of different stocks in one view.

The post How to Use Excel’s STOCKHISTORY Function appeared first on Xelplus - Leila Gharani.

]]> Excel Stock Data Type to Get Real-Time Stock Metrics https://www.xelplus.com/excel-stock-data/ Thu, 31 Dec 2020 10:38:00 +0000 https://www.xelplus.com/?p=10387 Get the latest stock data in Excel with Excel Data Types. You don't have to worry about the right formula. Everything gets written for you automatically. In this tutorial I show you how to set up your own stock portfolio in Excel from scratch.

The post Excel Stock Data Type to Get Real-Time Stock Metrics appeared first on Xelplus - Leila Gharani.

]]> Google Sheets vs. Excel – Is Google Sheets Better? https://www.xelplus.com/google-sheets-vs-excel/ Thu, 24 Sep 2020 09:00:00 +0000 https://www.xelplus.com/?p=10665 Is Google Sheets the right spreadsheet application for you? Or should you go with Excel? Here is a list of 10 features where Google Sheets beats Excel. It's a mix of Google sheets basic to advanced functions and hidden features.

The post Google Sheets vs. Excel – Is Google Sheets Better? appeared first on Xelplus - Leila Gharani.

]]>