Australian (ASX) Stock Market Forum

Live feed for Excel spreadsheet?

Joined
Oct 29, 2007
Posts
2
Reactions
0
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
 
Joined
Sep 28, 2007
Posts
1,472
Reactions
6
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.
 
Joined
Jan 10, 2010
Posts
1
Reactions
0
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.
 
Joined
Nov 13, 2011
Posts
1
Reactions
0
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.
 
Joined
Sep 7, 2011
Posts
356
Reactions
1
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.
 
Joined
Sep 7, 2011
Posts
356
Reactions
1
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.
 
Joined
Sep 29, 2013
Posts
1
Reactions
0
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/
 

Similar threads

Top