Read the Beforeitsnews.com story here. Advertise at Before It's News here.

By Stock Kevin (Reporter)
Contributor profile | More stories

Story Views
Now:
Last hour:
Last 24 hours:
Total:

Excel Tip #5 : How to Pull Stock Quotes into Excel 2010 from MSN Money

Sunday, March 10, 2013 3:16

% of readers think this story is Fact. Add your two cents.

Do you need to import stocks from a MSN Money to Microsoft Excel 2010?

From my past experiences with excel, I knew there was a way to import stock quotes from a Yahoo Finance or a MSN Money. But, when I googled “stock quotes into Excel”, a bunch of junk popped up. I wasn’t sure which was the correct way to do it.

MSN Money is directly linked to Excel No plug-in is required!

Microsoft Excel had been changed from previous versions. Prior to the Excel 2010 version, pulling stock quotes into excel required a plug-in. They removed this plug-in for Excel 2010 and later versions and actually just incorporated it in the software itself.

What I really wanted to do was to compare my stock portfolio that I tracked within excel with the most updated prices, without having to go look up each and every stock quote’s price.
Getting stock quotes into Excel 2010 is relatively easy.

Without further adieu here are the easy steps to importing stock quotes into Excel 2010.

1) Go to ‘Data’ tab –> click on ‘Connections’ –> ‘Add’

2) Select ‘MSN MoneyCentral Investor Stock Quotes’ and double-click or select open

3) Click on the newly added ‘MSN MoneyCentral Investor Stock Quotes’ connection and hit ‘Properties’

4) Make sure the ‘Enable background refresh’ is checked and any other setting you’d like have working for you

5) Go back to the ‘Data’ tab –> click on ‘Existing Connections’ and select the connection you added –> click open

6) A ‘Import Data’ box will appear and this is where you want to select where you want the data to appear.

7) Click ‘OK’. You will then be prompted with a ‘Enter Parameter Value’. Add the stock quotes separated by commas. (GOOG,AXP,KO,COP,DTV)
Note: Make sure you check ‘Use this value/reference for future refreshes’.

8) To refresh you data click the cell in which the data is located then go to tab ‘Data’ –> ‘Refresh All’ –> ‘Refresh’

Here is the final product.

And that is how you import Stock Quotes provided by MSN Money!

2013-03-10 03:08:24

Source: http://www.stockkevin.com/2013/03/how-to-pull-stock-quotes-into-excel.html

Source:

Before It’s News® is a community of individuals who report on what’s going on around them, from all around the world.

Anyone can join.
Anyone can contribute.
Anyone can become informed about their world.

"United We Stand" Click Here To Create Your Personal Citizen Journalist Account Today, Be Sure To Invite Your Friends.

Before It’s News® is a community of individuals who report on what’s going on around them, from all around the world. Anyone can join. Anyone can contribute. Anyone can become informed about their world. "United We Stand" Click Here To Create Your Personal Citizen Journalist Account Today, Be Sure To Invite Your Friends.

LION'S MANE PRODUCT

Try Our Lion’s Mane WHOLE MIND Nootropic Blend 60 Capsules

Mushrooms are having a moment. One fabulous fungus in particular, lion’s mane, may help improve memory, depression and anxiety symptoms. They are also an excellent source of nutrients that show promise as a therapy for dementia, and other neurodegenerative diseases. If you’re living with anxiety or depression, you may be curious about all the therapy options out there — including the natural ones.Our Lion’s Mane WHOLE MIND Nootropic Blend has been formulated to utilize the potency of Lion’s mane but also include the benefits of four other Highly Beneficial Mushrooms. Synergistically, they work together to Build your health through improving cognitive function and immunity regardless of your age. Our Nootropic not only improves your Cognitive Function and Activates your Immune System, but it benefits growth of Essential Gut Flora, further enhancing your Vitality.

Our Formula includes: Lion’s Mane Mushrooms which Increase Brain Power through nerve growth, lessen anxiety, reduce depression, and improve concentration. Its an excellent adaptogen, promotes sleep and improves immunity. Shiitake Mushrooms which Fight cancer cells and infectious disease, boost the immune system, promotes brain function, and serves as a source of B vitamins. Maitake Mushrooms which regulate blood sugar levels of diabetics, reduce hypertension and boosts the immune system. Reishi Mushrooms which Fight inflammation, liver disease, fatigue, tumor growth and cancer. They Improve skin disorders and soothes digestive problems, stomach ulcers and leaky gut syndrome. Chaga Mushrooms which have anti-aging effects, boost immune function, improve stamina and athletic performance, even act as a natural aphrodisiac, fighting diabetes and improving liver function. Try Our Lion’s Mane WHOLE MIND Nootropic Blend 60 Capsules Today. Be 100% Satisfied or Receive a Full Money Back Guarantee. Order Yours Today by Following This Link.