DolphinDB/codes/Sample_cal_indicators.dos

login(`admin, `123456)
loadPlugin("ODBC")

clearCachedModules()
use fundit::fundCalculator
use fundit::dataPuller
use fundit::returnCalculator
use fundit::indicatorCalculator


end_day = 2024.06.28
//end_day = today()

/* TEST CASE 1  */

fund_ids = "'HF000004KN','HF000103EU','HF00018WXG'";

/* TEST CASE 2 
tb_updated_funds = get_fund_list_by_nav_updatetime(null, 2024.07.19T10:00:00);

// take 1000 funds for testing
fund_ids = tb_updated_funds.fund_id[0:1000].concat("','")$STRING;
fund_ids = "'" + fund_ids + "'";
*/

d_indicators = fundit::indicatorCalculator::cal_fund_indicators('HF', fund_ids, end_day, true);
d_bfi_indicators = fundit::indicatorCalculator::cal_fund_bfi_indicators('HF', fund_ids, end_day, true);

                     
d_indicators['PBI-INCEP']
d_indicators['PBI-YTD']
d_indicators['PBI-3Y']
d_indicators['PBI-5Y']
d_indicators['MS-3Y']
d_bfi_indicators['BFI-INCEP']

/* TEST CASE 3 */


d_bfi_indicators = cal_fund_bfi_indicators('MF', "'MF00003RS0'", 2024.08.31, true);
//d_bfi_indicators = cal_fund_bfi_indicators('MF', "'MF00003PW2', 'MF00003PW1', 'MF00003PXO'", 2024.08.31, true);
SELECT * FROM d_bfi_indicators['BFI-1Y'] ORDER BY entity_id, benchmark_id, end_date