Dismiss Notice
Guest, I have a big favor to ask you. We've been working very hard to establish ourselves on social media. If you like/follow our pages it would be a HUGE help to us. SoSH on Facebook and Inside the Pylon Thanks! Nip

Live stock quotes into excel?

Discussion in 'BYTE ME: Technology discussion' started by Oil Can Dan, Feb 11, 2015.

  1. Oil Can Dan

    Oil Can Dan Well-Known Member Lifetime Member SoSH Member

    Messages:
    5,814
    I used to use MSN Money to get live stock quotes into excel, but it seems that no longer works.  I've googled around and found numerous tutorials on how to accomplish this, but each one has some thing that I either can't figure out or doesn't work.
     
    Does anyone know how to import live stock quotes into an excel spreadsheet? I'd like to track how much money I lose across all accounts in real-time!
     
  2. InsideTheParker

    InsideTheParker Member SoSH Member

    Messages:
    17,936
    I asked my husband, and this is what he said: 
    Go to finance.yahoo.com/quotes. Build your portfolio with add symbol. Save portfolio. Hit download (next to Add symbol box). Will download a csv file. Open with excel.
     
  3. mt8thsw9th

    mt8thsw9th anti-SoSHal SoSH Member

    Messages:
    15,937
     
    That will only give you the price when you downloaded the info (as far as I can tell).
     
    This might be what you are looking for.
     
  4. Oil Can Dan

    Oil Can Dan Well-Known Member Lifetime Member SoSH Member

    Messages:
    5,814
    Thanks.  Yeah, I spent a little time on that page earlier today.  They lost me at "click the Microsoft Office button", and then on "proofing".
     
    edit - should add that I figured out how to follow the instruction there but they simply don't work.  According to Microsoft XML for stock symbols is only available in outlook and word.
     
    This seems much harder than it should be.
     
  5. mt8thsw9th

    mt8thsw9th anti-SoSHal SoSH Member

    Messages:
    15,937
    Is it possible you're on a different version of Office than the instructions? I took a screen capture of me going through the instructions as listed on Excel 2007.
     
    https://www.youtube.com/watch?v=5owpaBHlVGk
     
    edit - It may under File>Options in your version of Excel. 
     
  6. Oil Can Dan

    Oil Can Dan Well-Known Member Lifetime Member SoSH Member

    Messages:
    5,814
    I'm on Office 365 - the web based version.
     
    My workflow on this is as follows:
     
    File > Options > Proofing > AutoCorrect Options > Actions
     
    At that point I can add the Date XML and that's it. I can then select "more actions", and then this webpage populates:
     
    https://support.office.microsoft.com/en-us/article/Built-in-Actions-8d01d867-4feb-4910-9072-afd2f9836609?AssetID=HA001050482&ver=15&app=excel.exe&CorrelationId=b770b686-9836-4583-bc87-e95dc96e427a&ui=en-US&rs=en-US&ad=US
     
    So then per that Microsoft website, it says:
     
    So, I don't think it's possible to do this in excel.  Which is crazy talk.
     
  7. HriniakPosterChild

    HriniakPosterChild Well-Known Member Gold Supporter SoSH Member

    Messages:
    10,086
     
    "Not possible to do this in excel" != "Not possible to do this in web based version"
     
  8. bibajesus

    bibajesus Member SoSH Member

    Messages:
    457
    Cant you just type "MOOO!" And "Oink!" Into the little boxes?
     
  9. Oil Can Dan

    Oil Can Dan Well-Known Member Lifetime Member SoSH Member

    Messages:
    5,814
    Ah, okay, so this is because I'm on this crappy 365 version then?
     
  10. HriniakPosterChild

    HriniakPosterChild Well-Known Member Gold Supporter SoSH Member

    Messages:
    10,086
     
    Don't you get a certain number of installs of the packaged product when you buy 365? 
     
  11. mt8thsw9th

    mt8thsw9th anti-SoSHal SoSH Member

    Messages:
    15,937
  12. Oil Can Dan

    Oil Can Dan Well-Known Member Lifetime Member SoSH Member

    Messages:
    5,814
    Thanks all - appreciate it.  I don't have access to a desktop version so looks like I'm outta luck.
     
  13. Oil Can Dan

    Oil Can Dan Well-Known Member Lifetime Member SoSH Member

    Messages:
    5,814
  14. Harrison Delfino

    Harrison Delfino lurker

    Messages:
    1
    I like using MarketXLS for this. It's great for me.
    Stock Quotes in Excel
     
  15. Section15Box113

    Section15Box113 Well-Known Member Lifetime Member SoSH Member

    Messages:
    5,862
    I unconditionally love this place. Thanks for sharing this!
     

Share This Page