Live feed for Excel spreadsheet?

[wandering]

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

 

[ROE]

Yes possible and very easy

http://www.mrexcel.com/tip103.shtml

 

[roland]

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

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.

 

[Yermo]

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

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.

 

[JohnDempsey]

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

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.

 

[LostMyShirt]

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.

 

[LostMyShirt]

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.

 

[SimCon]

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

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/