sample_cal_portfolio.dos 1.2 KB

12345678910111213141516171819202122232425262728293031323334
  1. login(`admin, `123456)
  2. loadPlugin("ODBC")
  3. clearCachedModules()
  4. use fundit::dataPuller
  5. use fundit::returnCalculator
  6. use fundit::indicatorCalculator
  7. use fundit::navCalculator
  8. very_old_date = 1990.01.01;
  9. /* TEST CASE 1, calculation_method = 1 */
  10. portfolio_ids = '166002,166114';
  11. cal_method = 1;
  12. /* TEST CASE 2, calculation_method = 2
  13. portfolio_ids = '364771';
  14. portfolio_ids = '364771,364772,364773,364774,364775,364776,364777,365070,364778,364779,365179,365180,365181,365164,365189,365198,365199,365200,365204,365205,365165,365166,365186,365187,365197,365201,365206,365167,365168,365171,365182,365183,365169,365170,365172,365173,365174,365175,365178,365194,365176,365177,365184,365185,365188,365190,365191,365192,365193,365195,365196,365202,365203';
  15. cal_method = 2;
  16. */
  17. // calculate navs
  18. tb_portfolio_nav = cal_portfolio_nav(portfolio_ids, very_old_date, cal_method);
  19. tb_portfolio_nav.sortBy!(['portfolio_id', 'price_date'], [1, 1]);
  20. // calculate indicators
  21. d_indicators = cal_portfolio_indicators(portfolio_ids, 2024.08.31, cal_method, true);
  22. d_bfi_indicators = cal_portfolio_bfi_indicators(portfolio_ids, 2024.08.31, cal_method, true);
  23. select * from d_indicators['PBI-1Y']
  24. select * from d_bfi_indicators['PBI-INCEP']