Home » Accounting » How to Get Stock Quotes in Excel Workbook

How to Get Stock Quotes in Excel Workbook

Download Business Management Templates Excel Dashboards KPI Reports

Get stock quotes directly in your Excel spreadsheet without wasting timeā€¦
After you open Excel choose Start out of the key managing process list. Following start you can choose Programs. Next, choose Microsoft Office in your computer applications list. Lastly, choose Microsoft Excel out of the Microsoft office environment list of applications.
Click the Data list out of the excel key list and then choose the option Get External Data out of the list of options in Excel. The Excel dialog box shows up along the list of options. Now, choose Investor Stock option.
Now you can choose a cell in your Excel spreadsheet for stock quote. You could also create a new sheet by using the Create New Worksheet alternative so you are able to put your stock quote within another / new Excel sheet. When choosing either one alternative, choose OK out of the dialog box.
Now enter a stock ticker in the dialog box in Excel. When you need to bring up to date the stock quote in long term, choose Use the value for long term will refresh. Likewise analyze the second check box in case you want the info to refresh by itself.
Now you can save Excel and use it anytime you need to check your stock quotes. Simply choose Save and name the Excel document. Save it to the adequate place on your computer so you can access it and open it anytime in the future.

Download Business Management Templates Excel Dashboards KPI Reports