Creating customized fundamentals
There are two kinds of fundamentals
in Timing Solution:
Time series and Single events.
Time series are day by day or week by week or any other period data. For
example, Sunspot activity number. It is the value calculated for Sunspot activity everyday,
it is
more than 150 years already.
This feature allows to draw together Sunspot activity index and some financial
instrument, let it be VIX:
We can assume that there is lagged (or leading) correlation between Sunspot
activity and implied volatility. The length of this lag is 4-5 years.
With Time series, we can explore different data in regards to different
markets.
Single events are instantaneous events that happen from time to time. For
example, the days when Feds change rates. Though these dates are announced
ahead and recorded, they are not periodic.
Look at S&P500 index chart together with
FED dates. Here they are (vertical stripes here correspond to those fundamental
dates):
In this case we can run Efficiency test module to see how S&P500 moves
around this fundamental event.
Building time series fundamentals
The easiest way to build customized time series fundamental event is:
- download this time series with Timing Solution. The standard downloading
module provides you a lot of options to download data of different formats.
- click this button and in the popup menu choose "To Fundamentals
folder" item:
The program will save it as a regular Excel *.csv file. You can
modify/update this file. Here are some examples of content of this file:
12.31.1749 23:59:60,94.05986
01.04.1750 15:39:30,94.53217
01.08.1750 07:18:60,95.0036
01.11.1750 22:58:29,95.47414
01.15.1750 14:37:59,95.94378
01.19.1750 06:17:29,96.41253
01.22.1750 21:56:59,96.88038
01.26.1750 13:36:29,97.34733
1.8.1818,65
1.13.1818,37
1.17.1818,77
1.18.1818,98
1.19.1818,105
1.25.1818,25
05.20.1994 13:30:00 0.0112663
05.21.1994 13:30:00 0.0101617
05.22.1994 13:30:01 0.0093511
05.23.1994 13:30:01 0.0087146
05.24.1994 13:30:02 0.0082382
05.25.1994 13:30:02 0.0080814
The date format here is MM/DD/YYYY
Now you can use these fundamentals' model regular way in ULE module: in
"Fundamental" tab, open your model and click "Calculate":
Pay attention: if you update fundamentals Excel files manually, click "Update
Fundamentals" button to reflect these changes in Timing Solution:
Building single events fundamentals
To create single events in Fundamentals tab, click this button:
Type there your events using MM/DD/YYYY date format:
Save this file. Let it be my_dates.fnd_d file ( *.fnd_d
extension is added automatically). And after that you can download and calculate this
fundamental regular way, exactly as you did with the previous model:
Pay attention: you can point the exact time for your events, in this case do
not forget to define the time zone, like this:
TZ=5W
07/22/2015 2:15PM
09/17/2015 9:34AM
It means that the first event took place on
07/22/2015 at 2:15PM; time zone here 5 hours West.
You can use military time style as well:
TZ=5W
07/22/2015 14:15
09/17/2015 9:34
If all events take place at the same time (but different date), you can
record these events this way:
TZ=5W
TIME=10:30
07/22/2015
09/17/2015
All these events took place at 10:30AM.