Stock Market Challenge

[mevetts]

Hi,

I have been delegated the task of running a share competition at work
I want to get the process fully automated.

Is there a way of building a workbook that imports all the stock marke
data, then have each team on a separate worksheet that is passwor
protected.

Each team can update their portfolio on their sheet and it will use th
stock market data to adjust accordingly.

I hope you get what I mean! Has anyone done this before, or know how
should go about setting it up?

Many thanks,

Mark

 

[Don Guillett]

You can goto yahoo groups xltraders and download a free file of mine to get
quotes. Look under donaldb36 as the author.

 

[mevetts]

I have downloaded a file called - 'YahooMultipleQuotes'

Is that the right one? Is there a way of getting it to pull data fro
the london stock exchange

 

[mevetts]

I have downloaded a file called - 'YahooMultipleQuotes'

Is that the right one? Is there a way of getting it to pull data fro
the london stock exchange

 

[Don Guillett]

I don't know. Give me a url. Send an email to my address with a good email
for you.

 

[mevetts]

Hi,

I've shelved the idea of building my own spreadsheet and am going to
use an online virtual stock exchange.

Thanks anyway,

Mark.

 

[Don Guillett]

I custom design financial spreadsheets

 

[mevetts]

I don't, hence this alternative approach. Far less work for me