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 market
data, then have each team on a separate worksheet that is password
protected.

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

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

Many thanks,

Mark.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=501624

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

--
Don Guillett
SalesAid Software

"mevetts" wrote in
message ...

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 market
data, then have each team on a separate worksheet that is password
protected.

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

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

Many thanks,

Mark.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile:
http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=501624

I have downloaded a file called - 'YahooMultipleQuotes'

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


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=501624

I have downloaded a file called - 'YahooMultipleQuotes'

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


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=501624

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

--
Don Guillett
SalesAid Software

"mevetts" wrote in
message ...

I have downloaded a file called - 'YahooMultipleQuotes'

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


--
mevetts


------------------------------------------------------------------------
mevetts's Profile:
http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=501624

Hi,

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

Thanks anyway,

Mark.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=501624

I custom design financial spreadsheets

--
Don Guillett
SalesAid Software

"mevetts" wrote in
message ...

Hi,

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

Thanks anyway,

Mark.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile:
http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=501624

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


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=501624