Stock Qoute In Excel Free Access To

I could then WebQuery to that file for each cell requiring that value.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged database macos excel excel-web-query or ask your own question.

The add-in works in the Excel Desktop version as well as online.

The list of available sources ranges from other Excel worksheets to other Office documents to databases--and just about everything in between.

Among my favorite outside data sources is an add-in called Stock Connector.

Stock Qoute In Excel Free Access To

Stock Connector provides free access to the current stock price of any security trading on any exchange tracked by Yahoo Finance.

You can also use Stock Connector to follow market indexes like the SP 500 (SPX).

Installing and using this free add-in can be accomplished with a few clicks.

If you reach the Office Store through a web browser, before you click the Add button, you should probably sign in to your Office 365 account if you have one--its just easier that way.

You can also reach the Office Store through the Insert tab in Excel.

Click the Store button and navigate to the Stock Connector page.

No matter how you get there, clicking the Add button ( Figure A ) will install the Stock Connector app.

Figure A.

Youll be presented with a list of installed add-ins; just click Stock Connector to activate the app.

A new window should open and youll see a search box where you can enter ticker symbols for the stocks or other securities you want to track ( Figure B ).

Figure B To insert a stock price into an Excel worksheet, click the cell where you want the price to display, type the ticker symbol of your stock into the Stock Connector search box, and then click the Connect button.

The add-in will search Yahoo Finance for the information and ask you to confirm the cell where you want to deposit it.

SEE: Six tips for using Excel sheet groups in easy (but unusual) ways For an example of how you might use Stock Connector, take a look at Figure C.

Then I added columns for how many fictional shares I own (C) and what fictional price I paid for them (D).

The next column (E) calculates my cost basis by multiplying C x D.

Figure C The next column (F) is where I inserted the market prices found by Stock Collector.

I used that information to calculate the market value of my shares (G) by multiplying C x F.

The next column (H) calculates my gain or loss based on the current market price by subtracting C from G.

The last column (I) shows how each stock is trending for the day, which comes directly from information gathered by Stock Connector.

To make gains and losses obvious at a glance, I took advantage of Excels conditional formatting.

Features Stock Connector will update the stock price instantly when you enter the ticker symbol for the first time and every 15 seconds after that for as long as you have the Excel worksheet open.

Stock Qoute In Excel For Mac