Hi, I have two time series for two data sets. For example, I have historical prices of gold and IBM. Sometimes you have extra trading dates for gold, or IBM, and I want to delete extra prices, so the two will be aligned with the same amount of data points (final format will be dates in column 1, Gold prices in column2, IBM in column3). Thank you for the help!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Time Series Data Cleaning
- Thread starter risk99
- Start date
SkipVought
Programmer
Hi,
Use Advanced Filter - UNIQUE VALUES (no criteria)
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]
Use Advanced Filter - UNIQUE VALUES (no criteria)
Skip,
[sub]
[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...Never hatchet your Counts before they chicken!
[/sub]- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Solved
- Locked
- Question