All Questions
Tagged with excel time-series
2 questions
0
votes
1
answer
227
views
cubic spline in excel with month, quarter and year inputs
Using Excel, how could I calculate a cubic spline curve in monthly granularity when my inputs are a combination of months, quarters and years? The quarter and yearly averages of the spline curve need ...
1
vote
0
answers
3k
views
Exporting Time Series Data For Securities Prices From Bloomberg to Excel
I have a list of securities over a thousand entries long that I want to construct a time series of prices for over a specified historical period (e.g. 2/01/10-2/20/10). Doing this manually would take ...
- 632