We have about 50 data sets created by Index-Lab that are used as external symbols in our strategies.
As we are batch processing our strategies every morning after having updated the data, I wonder if it is possible to batch update all the Index-Lab data sets listed by Index Manager.
Or any other solution to that problem.
Size:
Color:
Were you aware...
On the "Update Data" tab of "Data Manager", one of my "Historical Data Managers" is "Custom Indexes". If I check it and run Data Manager, it updates my (lone) index.
Hope this helps.
Len
Size:
Color:
Hi Len,
thank you very much. I'd like to try this, and have questions associated with it:
(1) What do you mean by "run Data Manager" ? Just open the Data Manager or open the Data Manager and press 'Update all data for selected Providers now' at the bottom?
(2) On the right side of 'Update Data', there is a scheduler for automated Data Updates. Assume that I have scheduled it. In order to be executed at the specified time, is it necessary that
(a) WL6 is open?
(b) Data Manager is Open?
(c) Update data knob is pressed?
(3) The title of this thread should read "'Batch 'Update Chart History' of Index-Lab Symbols (not DataSets)". An IndexLab symbol is the result of an indicator applied on a series of tickers collected in a DataSet. I'm still not sure whether the indexLab Symbols can be updated automatically. When I pressed 'Update all data for selected Providers now', the log shows:
QUOTE:
Updating Provider Custom Indexes ...
Updating INDEX MANAGER data ...
Symbols already up to date: %A-D_2_EQIDX_EM,%A-D_2_EQIDX_G7,%A-D_3_LME_INDUSTRIAL_METALS,%A-D_6_PMI_ASIA,%A-D_6_PMI_EU,%A-D_6_PMI_USA,%A-D_6_PMI_WORLD,%A-D_EXCH_RATES_NOK,%A-D_EXCH_RATES_SGD_R,%ADVPCT_US_MACRO_DIFFUSION,%AD_1_EQIDX,%AD_2_EQIDX_EM,%AD_2_EQIDX_G7,%AD_2_EQSEC_USA,%AD_2_SECTOR_INDEX_DIFFUSION,%AD_3_G_BONDS_GER,%AD_3_G_BONDS_USA_GER,%AD_3_G_EC_HEALTHY_5YR_UP,%AD_3_LME_INDUSTRIAL_METALS,%AD_6_PMI_ASIA,%AD_6_PMI_EU,%AD_6_PMI_USA,%AD_6_PMI_WORLD,%AD_8_RELPERFBREADTH_RX1,%AD_EXCH_RATES_AUD,%AD_EXCH_RATES_CAD,%AD_EXCH_RATES_EUR,%AD_EXCH_RATES_NOK,%AD_EXCH_RATES_SGD_R,%AD_EXCH_RATES_USD,%AD_GOLD_PRICE_ALL_FX,%EMAPCT_2_EQIDX_EM,%EMAPCT_2_EQIDX_G7,%EMAPCT_3_LME_INDUSTRIAL_METALS,%EMAPCT_6_PMI_ASIA,%EMAPCT_6_PMI_EU,%EMAPCT_6_PMI_USA,%EMAPCT_6_PMI_WORLD,%MKTSTR_US_MACRO_DIFFUSION,%PVI_1_ETF_KEY_EMRG,%PVI_1_ETF_KEY_EU,%PVI_1_ETF_KEY_USA,%RSI_GOLD_PRICE_ALL_FX,%TWIGGSMONEYFLOW_1_ETF_KEY_EMRG,%TWIGGSMONEYFLOW_1_ETF_KEY_EU,%TWIGGSMONEYFLOW_1_ETF_KEY_USA
It says 'Symbols already up to date' but this is not true. In fact nothing has been updated at all.
Eugene or Cone, can you clarify what conditions must be met to make an automatic update of symbols created by indexLab?
Size:
Color:
2. Not sure if the DM window should be left open, but for scheduled data updates WL6 surely must be running and the respective option in the DM must be activated.
3. (Naming doesn't matter but whatever you call it, only entire Index-Lab DataSets can be updated and not some individual "Index-Lab symbols".)
Your update log clearly suggests that there's nothing to update, and I tend to believe it. I guess that the data provider behind your IL DataSets does not support on demand data update - like ASCII or Metastock? Because for typical providers that support on demand updates it does work properly.
P.S. DataSets can be updated periodically by running a dummy strategy on them using Strategy Monitor, or with a programmatic workaround like
this or
that, but unfortunately, it doesn't apply to ASCII/MS-based DataSets incapable of on demand updates.
Size:
Color:
Thank you for your answer.
We use Bloomberg Static (EOD) data and I believe that it doesn't support on demand updates. This would explain the behaviour.
Size:
Color:
Yes, this provider doesn't support on demand updates, too.
Size:
Color: