rici76
01-21-2009, 01:59 PM
Hi All,
I am new to this forum so I do not know how things are usually done around here (for example if I can just ask for help without having contributed anything)...
I'll give it a try anyway, here it goes...
What I am trying to do is download real-time data from Bloomberg and build a simple data base with those values being downloaded.
Prices (data) is being downloaded constantly but I would be happy if the prices are just copied into the database every 2 minutes for example. I would not need a very long data base, so it would be ideal to roll out older data and swap it for new one.
I hope my description makes some sense to you guys, but there is nothing better than an example to make things clearer...
So let's assume the prices are downloaded into cell D7:
Time 7:00 Price in D7: 120
Time 7:01 Price in D7:120.1
Time 7:02 Price in D7: 120.3 etc, etc....
now what I would like to have is a makro that takes that value at 7:00 and copies it into a database (Column), then at 7:01, 7:02 etc... until let's say 7:30 at which time the value for 7:00 is deleted and replaced with the value for 7:31 and so on...
Not sure if it made it clearer but I believe so....
Should anybody be willing and able to solve this problem but feels like he/she hasn't fully understood my explanation please feel free to ask any questions.
Many thanks in advance to all.
Cheers Rici
I am new to this forum so I do not know how things are usually done around here (for example if I can just ask for help without having contributed anything)...
I'll give it a try anyway, here it goes...
What I am trying to do is download real-time data from Bloomberg and build a simple data base with those values being downloaded.
Prices (data) is being downloaded constantly but I would be happy if the prices are just copied into the database every 2 minutes for example. I would not need a very long data base, so it would be ideal to roll out older data and swap it for new one.
I hope my description makes some sense to you guys, but there is nothing better than an example to make things clearer...
So let's assume the prices are downloaded into cell D7:
Time 7:00 Price in D7: 120
Time 7:01 Price in D7:120.1
Time 7:02 Price in D7: 120.3 etc, etc....
now what I would like to have is a makro that takes that value at 7:00 and copies it into a database (Column), then at 7:01, 7:02 etc... until let's say 7:30 at which time the value for 7:00 is deleted and replaced with the value for 7:31 and so on...
Not sure if it made it clearer but I believe so....
Should anybody be willing and able to solve this problem but feels like he/she hasn't fully understood my explanation please feel free to ask any questions.
Many thanks in advance to all.
Cheers Rici