• Australian (ASX) Stock Market Forum

Hello and welcome to Aussie Stock Forums!

To gain full access you must register. Registration is free and takes only a few seconds to complete.

Already a member? Log in here.

Live feed for Excel spreadsheet?

Discussion in 'Software and Data' started by wandering, Oct 29, 2007.

  1. wandering

    wandering

    Posts:
    2
    Likes Received:
    0
    Joined:
    Oct 29, 2007
    I am new here, and this is my first post. I did search and could find nothing, and hope that this is in the correct forum.

    I am wanting to get a live feed for the latest traded price (20 minute delay is acceptable) in a cell in an excel spreadsheet.

    Is this possible?

    If so, how do I do it?

    MTIA

    w
     
  2. ROE

    ROE

    Posts:
    2,966
    Likes Received:
    16
    Joined:
    Jan 5, 2007
  3. roland

    roland

    Posts:
    1,472
    Likes Received:
    6
    Joined:
    Sep 28, 2007
    I wonder why you bother, have a look here: http://www.personalstockmonitor.com/

    this is what I use. I have no links with this company, but have used Personal Stock Monitor Gold for 3 years now - beats an excel spreadsheet in every way.
     
  4. Yermo

    Yermo

    Posts:
    1
    Likes Received:
    0
    Joined:
    Jan 10, 2010
    I am with the company that produces Personal Stock Monitor (PSM for short).

    With PSM it's very easy. Just open PSM, add the tickers you want to track, then drag and drop them from PSM into your Excel spreadsheet. This creates a DDE link between PSM and Excel so the cells in Excel will update when PSM does.

    For finer control, if you know VBScript, you can also write a script extension to do the same thing.

    If you have any questions or need some help, let me know.
     
  5. JohnDempsey

    JohnDempsey

    Posts:
    1
    Likes Received:
    0
    Joined:
    Nov 13, 2011
    For restoring excel files try Excel repair. Software is able to restore excel files after malicious software, system errors, accidentally deleting. The program can help you to solve out such troubles owing to easy to use Recovery Wizard, which not to require special knowledges.
     
  6. LostMyShirt

    LostMyShirt

    Posts:
    356
    Likes Received:
    0
    Joined:
    Sep 7, 2011
    The issue with using Yahoo for the data is that they round up some of their prices.

    For instance Fridays last trade on DML was 1.375, but shows up as 1.38. This half a cent has plety of meaning, and I don't think having rounded figures on stock prices is the right way to go.
     
  7. LostMyShirt

    LostMyShirt

    Posts:
    356
    Likes Received:
    0
    Joined:
    Sep 7, 2011
    Sorry for the double post, I just needed to add one more bit of info.

    For ASX shares Yahoo does indeed round the values. They sometimes flash back to proper 3 decimal values but when you add the table from Yahoo it shows up rounded in your spreadsheet.

    It would be best to use the Trading Room website for tables.

    www.tradingroom.com.au

    Get a quote and add the table provided in the summary.

    Now, I realize this may interfere with peoples spreadsheets where they only want a quoted price on their jeornal and not the entire table.

    What you can do is create another sheet on your spreadsheet. You can call it "data table" or something along those lines, but that is the purpose.

    Put the table in your extra sheet, and then go back to your jeornal to the column where your input for last traded price is, then link that cell to the data table sheet specifically on the last traded price.

    So, your Data sheet has a table for XYZ stock, which features highs, lows, last traded etc etc. On your trading jeornal wher you want the last price put in, run the following formula;

    =sum(cell with last traded price)

    This way when you refresh your data it will reflect the last traded price on your jeornal without having a whole table intrude on your sheet.

    I hope this helps everyone who tries to do this with live data - it certainly is a fantastic tool.
     
  8. SimCon

    SimCon

    Posts:
    1
    Likes Received:
    0
    Joined:
    Sep 29, 2013
    This is pretty easy to do with Excel's web query tools. This website has a tutorial specifically for this - it tells you how to link the live gold spot rate from Yahoo Finance to Excel: http://investexcel.net/4379/live-gold-spot-price-excel/
     
Loading...

Share This Page