Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Hello,
I need to unify data from the Bloomberg portal, the problem is as there are assets from all around the world, they are not uniformly. Meaning, that for example Europe has no trading day on Christmas, so there is no input on this day, but the assets from Asia for example got traded on this day, so there is an input for them. and as the data set is for the past 17 years, there are many of these discrepancies . How can i unify them without going through them each by each? Thanks for the help :-) |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I need to unify data from the Bloomberg portal, the problem is as there are assets from all around the world, they are not uniformly. Meaning, that for example Europe has no trading day on Christmas, so there is no input on this day, but the assets from Asia for example got traded on this day, so there is an input for them. and as the data set is for the past 17 years, there are many of these discrepancies . How can i unify them without going through them each by each? Thanks for the help :-) Why then, would the dates where no trading was done not be just left blank? Otherwise, what do you mean by uniformity/discrepancies? What is it, exactly, that you want to accomplish? -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
paste to different rows on different dates | Excel Discussion (Misc queries) | |||
delete rows with dates between | Excel Programming | |||
Delete Rows whose value is not between 2 dates | Excel Programming | |||
Delete Rows with particular dates | Excel Programming | |||
hide rows with any dates | Excel Programming |