Australia's largest stock trading and investment forum Australia's #1 stock forum

Excel Spreadsheets and Trading, page-4

First 4 Last

Share
Profile

Follow
bruceyg

35,295 Posts.

3

17/07/14

17:51

Post #: 13676165
Share

Originally posted by el3ctro ↑

Hi Everyone,

I hope you are all well!

I am just seeking a bit of information and know how from the HC community!

I am looking for a bit of advice with the technical points of excel - I would like to create a sheet that scrapes data from a live source.

1. Is it possible to have a spreadsheet that gives me a live feed (changing as the SP on market does)
2. What site could I use for this?
3. Am I able to somehow link this to my Commsec account?
4. I would like to manually enter a stock code, then the relevant information that I require pops into my spreadsheet - I know you can do this using google finance, however I have found it to be not quite as accurate as Commsec, eg I would like the SP to 4dec places.

Thank you!

E

Expand

there is a little excel sheet here that i have - it hasnt got all the bells and whistles but it is handy - and with excel you can throw in a chart or two - it has Date Open High Low Close Volume Adj Close

http://investexcel.net
3 Upvote

Reply

Top Stories

ASX Market Close: Local bourse dips red as CBA profit takers swoop

ASX Market Open: Oz shares dip back (very slightly) after Wed's record close | July 3

CCO

The Calmer Co FY25 revenue hits $8 million, up 86% on FY24

SFM

Why is Santa Fe Minerals up 370% on Thursday?

CBA

CBA down as BHP goes up – what's going on, and, will CBA stocks correct?

Listen: HotCopper Wire Podcast 016 – FY25 ended up not so bad... but Trump unpause is coming

Trump chides Powell as Goldman call for calm. The RBA must be nervous

RML

Resolution looks to 'strong historical data' as Horse Heaven search begins

GLF

Gemlife used the ASX's new IPO fast-track. Is this the start of a new cycle?

Thursday's HotCopper trends: Vault Q4 miss, Peak raise | July 3

First 4 Last

SPONSORED BY