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,073 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

SBW

Shekel Brainweigh investor presentation webinar – the future of retail automation

BIT

HotCopper users blunt as Biotron sinks -35%; long-awaited COVID drug results same as placebo

CBA breaks trading record on strong day for Aussie financials

Week 36 Wrap: AI hype wave tested again; Oz per capita recession continues; AirTrunk’s $40B+ payday

PRU

Perseus Mining boosts stake in Predictive Discovery to 19.9% as latter's flagship project stalls

As Nvidia cools, we're looking to Aussie AI

OCC

Orthocell kicks off collagen-based dental bone repair product sales in Canada; eyeing next stop Brazil

LAM

Laramide sniffs prime Kazakh uranium, with agreement over 6000 square km land position

RMX

Red Mountain Mining: record gold prices, two projects, two greenstone belts

QML

Metallurgical testing shows saleable copper and pyrite from QMines' Develin Creek project

There are more pages in this discussion • 19 more messages in this thread...

First 4 Last