Hi!
This should be pretty easy but there are a couple of=20
things that I don't quite understand.
Do you download the raw data daily? And if so, after you=20
have that data sorted out to the other sheet do you delete=20
the raw data?
Where do you get the closing values?=20
I can think of a few different ways to do this but at the=20
same time it sounds like this file is very big and would=20
require a lot of formulas.
Have you considered using a pivot table or even a database=20
program?
To come up with a specific solution I would need to see=20
the file.
Biff
-----Original Message-----
Date Company Name Mnemonic opening
3-1-2005 ABN AMRO HOLDINGAABA 19,53
3-1-2005 AEGON AGN 10,09
3-1-2005 AHOLD KON AH 5,67
3-1-2005 AKZO NOBEL AKZA 31,25
3-1-2005 ASML HOLDING ASML 11,76
3-1-2005 BUHRMANN BUHR 7,2
3-1-2005 DSM DSM 47,51
3-1-2005 ELSEVIER REN 10,04
3-1-2005 FORTIS FORA 20,44
3-1-2005 GETRONICS GTN 1,68
3-1-2005 HAGEMEYER HGM 1,72
3-1-2005 HEINEKEN HEIA 24,55
3-1-2005 IHC CALAND IHC 46,65
So this is my Data input as I can download it from the=20
server what I would=20
like now is that this number you can see under opening is=20
being looked up in=20
another worksheet.
But now the A column states all the different dates and=20
the first row states=20
the different companies so that i don't have to copy=20
everything by hand.
As you can see the date here is only the 3rd of january=20
but in the complete=20
worksheet this must accumulate to a whole year as time=20
goes by and I can=20
download the data weekly.
Like this:
AABA=09
=09
Date Open End
3-01-05 =E2,=AC 19,53 =E2,=AC 19,70=20
4-01-05 =E2,=AC 19,65 =E2,=AC 19,82=20
5-01-05 =E2,=AC 19,66 =E2,=AC 19,76=20
6-01-05 =E2,=AC 19,80 =E2,=AC 20,48=20
7-01-05 =E2,=AC 20,46 =E2,=AC 20,65=20
10-01-05 =E2,=AC 20,56 =E2,=AC 20,58=20
11-01-05 =E2,=AC 20,52 =E2,=AC 20,28=20
12-01-05 =E2,=AC 20,24 =E2,=AC 20,06=20
13-01-05 =E2,=AC 20,14 =E2,=AC 20,09=20
14-01-05 =E2,=AC 19,98 =E2,=AC 20,11=20
17-01-05 =E2,=AC 20,17 =E2,=AC 20,27=20
18-01-05 =E2,=AC 20,51 =E2,=AC 20,56=20
19-01-05 =E2,=AC 20,64 =E2,=AC 20,69=20
20-01-05 =E2,=AC 20,62 =E2,=AC 20,61=20
21-01-05 =E2,=AC 20,53 =E2,=AC 20,73=20
24-01-05 =E2,=AC 20,66 =E2,=AC 20,64=20
25-01-05 =E2,=AC 20,72 =E2,=AC 20,84=20
And then if this would be columns A through C but in the=20
complete worksheet=20
it goes through to AQ
Again is this possible?
"Biff" wrote:
Hi!
=20
Can't really tell what it is you want.
=20
Can you provide more detailed info? Be very specific.
=20
Biff
=20
-----Original Message-----
Ok what I need to do is to get the number from a=20
certain=20
cell with all kinds=20
of data (Stocks) into a worksheet in wich I can modify=20
my=20
investments.
Now the problem is that I get the data in the=20
following=20
order:
DATE COMPANY HIGH LOW VOLUME
x x x x x =20
What I would like now is that as I will have to add=20
more=20
data that the=20
'HIGH' and 'LOW' will be copied within a formula to=20
another worksheet in=20
which the Date can be found on the different rows and=20
all=20
the companies are=20
filled in the columns now there are 24 different=20
companies I have to aquire=20
the stockindexes from.
Will this be possible? What I can do is to get all the=20
first stock indexes=20
correctly but as I try to autofill all the dates it=20
doesn't seem to work with=20
only just the VLOOKUP formula!
Any help will be greatly appreciated.
.
=20
.
|