6
votes
2answers
153 views

Select elements of list within a date range

I have a list which consists of elements each of which has a date in DateList format, a number and a flag (Y/N). e.g. ...
7
votes
3answers
242 views

Find all the last weekends in a year

In order to obtain the weekends of a year you'd use something like this: ...
6
votes
5answers
222 views

Handling holidays in financial time series

I have two lists: list1and list2, which are financial time series with only 2 variables—date and price. The problem is: these ...
5
votes
2answers
235 views

Finding the intersection of two date lists

I've got two lists that look like this ...
7
votes
3answers
204 views

Filter list based on date

What I would like to do is remove entries from a list of instrument data when it is in maintenance. The maintenance data I have is a series of dates which look like this; ...
10
votes
3answers
325 views

Simpler way to fill date gaps with zero values

One basic problem when working with data like sales and dates is the case where you dont't have sales in all days, so you have to fill it to take information as average or to make a plot. See this toy ...
6
votes
3answers
131 views

Importing and manipulating strings - time data

I have a list of time durations, which are strings of the form: "hh:mm:ss". Here's a sample for you to play with: ...
6
votes
2answers
121 views

DateList Segmentation of data

I've been trying to separate large segments of DateList formatted data (years worth at a time) into individual days using the Split function. The data has the form: ...
10
votes
7answers
179 views

DateList coupled with String Operations

Through some webscraping, I have the following list: ...
5
votes
2answers
214 views

From a list of dates get a list of the last date available in a each month

I wondered if anyone has another or even a more direct way of finding the last dates of each month available from a list of successive dates? I currently do the following (note: nothing special about ...