Alignment Systems

Software and consultancy services for asset managers and hedge funds

MSRS Version 1.3 Information

Version / Patch Number Release Date Status Date of update
1.3   Current development version 29th October 2003

MSRS Version 1.3 Details

Version Number Details   Date of update
1.3     29th October 2003

MSRS Version 1.3 High Level Changes

1 Enhancement of  Real Time Data data model and data dictionary. Portfolio modelling using real time data

rtd_provider_types
rtd_providers
rtd_scheme_to_provider_link
rtd_schemes
2 Enhancement and extension of client data model:

client_address_data
client_address_types
client_classification
client_communication_data
client_communication_type_data
client_objective_data
client_risk_profile_data
client_static_data
client_type_data
3 Introduction of importable worksheets functionality

importable_workbooks
importable_worksheets
importable_worksheets_schemes
importable_worksheets_to_scheme_linker
4 Introduction of "look through" functionality

look_through_schemes
look_through_underlying
5 Enhancement of application level security model

application_security_person_portfolio_role_link
application_security_role_data
6 Introduction of document management capability

client_document_management_data
client_document_type_data
7 Introduction of "Grid" proof-of-concept

create_grid_jobs
create_grid_members
8 Introduction of performance measurement integration

history_data
9 Introduction of historical portfolio valuation integration

history_data

   

MSRS Version 1.3 Changes from 1.2

Area - Database Details Date of update
pro_sp_GET_algorithm_parameters_for_scheme_id Rename from script to algorithm 8/7/2003
pro_sp_GET_algorithm_parameters_for_scheme_id Logic improvements 9/7/2003
pro_sp_GET_algorithm_parameters_for_scheme_id Added in roots of security model 13/8/2003
pro_sp_GET_algorithm_storage Rename from script to algorithm 8/7/2003
pro_sp_GET_algorithm_storage Added in roots of security model 13/8/2003
pro_sp_GET_algorithms_for_scheme_id Rename from script to algorithm 8/7/2003
pro_sp_GET_algorithms_for_scheme_id Logic improvements 9/7/2003
pro_sp_GET_algorithms_for_scheme_id Added in roots of security model 13/8/2003
pro_sp_GET_AppServer_id Logic improvements 7/4/2003
pro_sp_GET_bop_static_data  Logic improvements 8/4/2003
pro_sp_GET_bop_static_data Logic improvements 14/6/2003
pro_sp_GET_bop_static_data Added in roots of security model 13/8/2003
pro_sp_GET_bop_static_data Logic improvements 16/10/2003
pro_sp_GET_client_data Addition 21/10/2003
pro_sp_GET_client_document_management_data Addition 22/10/2003
pro_sp_GET_create_grid_job_members Addition 17/7/2003
pro_sp_GET_create_grid_job_members Logic improvements 18/7/2003
pro_sp_GET_create_grid_job_members Added in roots of security model 13/8/2003
pro_sp_GET_create_grid_jobs Addition 17/7/2003
pro_sp_GET_create_grid_jobs Added in roots of security model 13/8/2003
pro_sp_GET_data_2 Addition 10/3/2003
pro_sp_GET_data_2 Logic Improvements 12/3/2003
pro_sp_GET_data_2 Logic Improvements 17/3/2003
pro_sp_GET_data_2 Logic Improvements 18/3/2003
pro_sp_GET_data_2 Logic Improvements 21/3/2003
pro_sp_GET_data_2 Logic Improvements 24/3/2003
pro_sp_GET_data_2 Logic Improvements 26/3/2003
pro_sp_GET_data_2 Logic Improvements 28/3/2003
pro_sp_GET_data_2 Logic Improvements 7/4/2003
pro_sp_GET_data_2 Logic Improvements 13/5/2003
pro_sp_GET_data_2 Logic Improvements 7/7/2003
pro_sp_GET_data_2 Logic Improvements 16/7/2003
pro_sp_GET_data_2 Logic Improvements 13/8/2003
pro_sp_GET_data_2 Logic Improvements 5/10/2003
pro_sp_GET_data_2 Logic Improvements 8/10/2003
pro_sp_GET_data_2 Logic Improvements 16/10/2003
pro_sp_GET_history_data Addition 12/7/2003
pro_sp_GET_history_data Logic Improvements 13/8/2003
pro_sp_GET_import_data Addition 2/6/2003
pro_sp_GET_import_data Logic Improvements 13/8/2003
pro_sp_GET_job_from_queue Addition 18/5/2003
pro_sp_GET_job_from_queue Logic Improvements 22/6/2003
pro_sp_GET_job_from_queue Logic Improvements 1/8/2003
pro_sp_GET_job_from_queue Added in roots of security model 13/8/2003
pro_sp_GET_job_from_queue Logic Improvements 22/10/2003
pro_sp_GET_jobs_from_queue Addition 18/1/2003
pro_sp_GET_jobs_from_queue Logic Improvements 19/1/2003
pro_sp_GET_jobs_from_queue Logic Improvements 10/3/2003
pro_sp_GET_jobs_from_queue Logic Improvements 25/3/2003
pro_sp_GET_jobs_from_queue Logic Improvements 19/4/2003
pro_sp_GET_jobs_from_queue Logic Improvements 26/4/2003
pro_sp_GET_jobs_from_queue Logic Improvements 6/6/2003
pro_sp_GET_jobs_from_queue Logic Improvements 10/6/2003
pro_sp_GET_jobs_from_queue Logic Improvements 14/6/2003
pro_sp_GET_jobs_from_queue Logic Improvements 19/6/2003
pro_sp_GET_jobs_from_queue Logic Improvements 22/6/2003
pro_sp_GET_jobs_from_queue Logic Improvements 16/7/2003
pro_sp_GET_jobs_from_queue Logic Improvements 13/8/2003
pro_sp_GET_jobs_from_queue Logic Improvements 3/10/2003
pro_sp_GET_license Addition 18/4/2003
pro_sp_GET_look_through Addition 5/10/2003
pro_sp_GET_order_basket_proposals Addition 7/10/2003
pro_sp_GET_order_single_proposals Addition 7/10/2003
pro_sp_GET_presentation_column_data Addition 26/3/2003
pro_sp_GET_presentation_column_data Logic Improvements 9/5/2003
pro_sp_GET_presentation_column_data Added in roots of security model 13/8/2003
pro_sp_GET_rtd_data Addition 22/6/2003
pro_sp_GET_rtd_data Logic Improvements 11/7/2003
pro_sp_GET_rtd_data Logic Improvements 12/7/2003
pro_sp_GET_rtd_data Added in roots of security model 13/8/2003
pro_sp_GET_UI_algorithm_schemes Addition 19/6/2003
pro_sp_GET_UI_algorithm_schemes Logic Improvements 27/6/2003
pro_sp_GET_UI_algorithm_schemes Logic Improvements 20/6/2003
pro_sp_GET_UI_algorithm_schemes Rename from script to algorithm 8/7/2003
pro_sp_GET_UI_algorithm_types Addition 29/9/2003
pro_sp_GET_UI_algorithms Addition 23/6/2003
pro_sp_GET_UI_algorithms Logic Improvements 27/6/2003
pro_sp_GET_UI_algorithms Rename from script to algorithm 8/7/2003
pro_sp_GET_UI_algorithms Logic Improvements 29/9/2003
pro_sp_GET_UI_benchmark_data Addition 24/3/2003
pro_sp_GET_UI_benchmark_ids Addition 22/4/2003
pro_sp_GET_UI_create_jobs Addition 16/5/2003
pro_sp_GET_UI_create_jobs Logic Improvements 8/6/2003
pro_sp_GET_UI_holdings_by_instrument Addition 20/10/2003
pro_sp_GET_UI_holdings_by_instrument Logic Improvements 29/10/2003
pro_sp_GET_UI_holdings_by_instrument_and_depot Addition 20/10/2003
pro_sp_GET_UI_holdings_by_instrument_per_depot Addition 20/10/2003
pro_sp_GET_UI_importable_worksheet_schemes Addition 19/6/2003
pro_sp_GET_UI_instruments_by_name Addition 20/10/2003
pro_sp_GET_UI_portfolio_data Addition 22/4/2003
pro_sp_GET_UI_portfolio_data Logic Improvements 14/6/2003
pro_sp_GET_UI_portfolio_data Logic Improvements 23/6/2003
pro_sp_GET_UI_portfolio_data Logic Improvements 28/10/2003
pro_sp_GET_UI_portfolio_ids Addition 22/4/2003
pro_sp_GET_UI_portfolio_ids Logic Improvements 14/6/2003
pro_sp_GET_UI_presentation_set_ids Addition 22/4/2003
pro_sp_GET_UI_rtd_schemes Addition 22/6/2003
pro_sp_GET_UI_save_as_locations Addition 22/4/2003
pro_sp_GET_UI_save_as_locations Modified 26/4/2003
pro_sp_GET_UI_scheme_algorithms Addition 16/5/2003
pro_sp_GET_UI_scheme_algorithms Modified 8/7/2003
pro_sp_GET_UI_scheme_algorithms Modified 17/10/2003
pro_sp_GET_UI_scheme_not_algorithms Addition 27/6/2003
pro_sp_GET_UI_scheme_not_algorithms Logic Improvements 7/7/2003
pro_sp_GET_UI_scheme_not_algorithms Rename from script to algorithm 8/7/2003
pro_sp_GET_UI_scheme_parameters_for_algorithm Addition 1/7/2003
pro_sp_GET_UI_scheme_parameters_for_algorithm Logic Improvements 3/7/2003
pro_sp_GET_UI_scheme_parameters_for_algorithm Rename from script to algorithm 8/7/2003
pro_sp_GET_UI_server_ids Addition 22/4/2003
pro_sp_GET_UI_sp_names Addition 22/4/2003
pro_sp_GET_UI_user_database_id Addition 13/5/2003
pro_sp_GET_UI_user_ids Addition 19/6/2003
pro_sp_GET_user_security_token Addition 26/6/2003
pro_sp_GET_user_security_token Logic Improvements 9/10/2003
pro_sp_GET_UserServer_id Addition 18/2/2003
pro_sp_GET_UserServer_id Logic Improvements 7/4/2003
pro_sp_GET_valuation_data Addition 31/3/2003
pro_sp_GET_valuation_data Logic Improvements 7/4/2003
pro_sp_GET_valuation_data Added in roots of security model 13/8/2003
pro_sp_load_API_benchmark_data_row Addition 28/2/2003
pro_sp_load_API_benchmark_data_row Logic Improvements 24/3/2003
pro_sp_load_API_bop_static_data_row    
pro_sp_load_API_client_address_data    
pro_sp_load_API_client_communication_data    
pro_sp_load_API_client_data
pro_sp_load_API_client_document_management_data    
pro_sp_load_API_currency_static_data_row    
pro_sp_load_API_data_source_static_data_row    
pro_sp_load_API_dynamic_reclassification_duration_1    
pro_sp_load_API_fx_data_row    
pro_sp_load_API_held_data_row    
pro_sp_load_API_person_static_data_row    
pro_sp_load_API_securities_data_row    
pro_sp_load_API_securities_eq_data_row    
pro_sp_load_API_securities_fi_data_row    
pro_sp_load_API_securities_id_data_row    
pro_sp_load_API_securities_pr_data_row    
pro_sp_load_API_security_classification_one_link_data_row    
pro_sp_load_API_security_classification_row    
pro_sp_load_benchmark_data_set_one    
pro_sp_load_bop_static_data_block    
pro_sp_load_cf_code_names    
pro_sp_load_clean_bop_holding_data    
pro_sp_load_clean_fx_data    
pro_sp_load_clean_temp_benchmark_data_set_one    
pro_sp_load_clean_temp_fmc_portfolio_static_data    
pro_sp_load_clean_temp_fmc_security_classification_one_data    
pro_sp_load_clean_temp_ftse_uk_gilt_index_constituents_data    
pro_sp_load_clean_temp_fx_data    
pro_sp_load_clean_temp_portfolio_holdings_data    
pro_sp_load_clean_temp_securities_data    
pro_sp_load_currency_static_data_block    
pro_sp_load_fx_data_block    
pro_sp_load_held_data_block    
pro_sp_load_INI_client_classification_data    
pro_sp_load_INI_client_communication_type_data    
pro_sp_load_INI_client_document_type_data    
pro_sp_load_INI_client_objective_data    
pro_sp_load_INI_client_risk_profile_data    
pro_sp_load_INI_client_type_data    
pro_sp_load_INI_country_data    
pro_sp_load_INI_depot_data    
pro_sp_load_INI_environment_algorithm_primary_types    
pro_sp_load_INI_environment_application_roles    
pro_sp_load_INI_environment_bop_types    
pro_sp_load_INI_environment_classification_scheme_setup_1    
pro_sp_load_INI_environment_configuration_data    
pro_sp_load_INI_environment_create_jobs    
pro_sp_load_INI_environment_currency_static_data    
pro_sp_load_INI_environment_data_vendor_static    
pro_sp_load_INI_environment_dynamic_reclassification_scheme_setup_1    
pro_sp_load_INI_environment_exchange_data    
pro_sp_load_INI_environment_held_basis    
pro_sp_load_INI_environment_instrument_identifiers_static_data    
pro_sp_load_INI_environment_load_domains    
pro_sp_load_INI_environment_load_job_types    
pro_sp_load_INI_environment_load_jobs    
pro_sp_load_INI_environment_master    
pro_sp_load_INI_environment_message_levels    
pro_sp_load_INI_environment_messages    
pro_sp_load_INI_environment_presentation_set_1    
pro_sp_load_INI_environment_pricing_logicals    
pro_sp_load_INI_environment_script_languages    
pro_sp_load_INI_environment_server_static_data    
pro_sp_load_INI_environment_user    
pro_sp_load_INI_environment_user_security_data    
pro_sp_load_INI_instrument_primary_types    
pro_sp_load_INI_rtd_data    
pro_sp_load_INI_script_example    
pro_sp_load_INI_workbook_example    
pro_sp_load_runtime_setup_default_security    
pro_sp_load_securities_data_block    
pro_sp_load_security_classification_one_data_block    
pro_sp_load_security_classification_one_data_link_block    
pro_sp_load_status    
pro_sp_load_truncate_temp_benchmark_data_set_one    
pro_sp_load_truncate_temp_classification_one_data    
pro_sp_load_truncate_temp_ftse_uk_gilt_index_constituents_data    
pro_sp_load_truncate_temp_ftse_uk_gilt_index_constituents_data2    
pro_sp_load_truncate_temp_fx_rates    
pro_sp_load_truncate_temp_global_currency_static_data    
pro_sp_load_truncate_temp_portfolio_holdings_data    
pro_sp_load_truncate_temp_portfolio_static_data    
pro_sp_load_truncate_temp_securities_data    
pro_sp_maintenance_cycle_error_log    
pro_sp_maintenance_list_options    
pro_sp_maintenance_list_users    
pro_sp_maintenance_recompile    
pro_sp_maintenance_validate_algorithm_pointers    
pro_sp_PUT_Algorithm_Script    
pro_sp_PUT_AppServer_health_state    
pro_sp_PUT_AppServer_status    
pro_sp_PUT_rebalance_output_daily_portfolio    
pro_sp_PUT_UI_algorithm_scheme    
pro_sp_PUT_UI_scheme_algorithms    
     
Area - Application Version   
[iii] Script Engine Version:
[iii] ADO Version: 
[iii] MSHFlexGrid Version
[iii] MSFlexGrid Version
Excel COM+ AddIn Version: 
Algorithm Engine Version: 
BOP Version: 
Export Library Version: 
Import Library Version: 
Health Status Version: 
Logger Version: 
Server Object Version:
Alignment Work Version: 
License Manager Version
Interfaces Version
Grid Version
Look Through Version
[ocx] Basket Selector
[ocx] Block Member List
[ocx] Block Picker
[ocx] Log File Browser
[ocx] Order Authorisation
[ocx] Order List
[ocx] Order Transmission
[ocx] Order Type
[ocx] Create Job
[ocx] Algorithm design
[ocx] Immediate Job
[ocx] Stock Picker
[ocx] User Report
Helper Version: 
Order Release Management Version
Alignment Manager Version
 
5.6.7426
2.7
6
6
1.3.256
1.3.436
1.3.597
1.3.461
1.3.234
1.3.471
1.3.505
1.3.336
1.3.458
1.3.309
1.3.517
1.3.210
1.3.94
1.3.72
1.3.22
1.3.18
1.3.357
1.3.66
1.3.71
1.3.65
1.3.31
1.1.20
1.3.370
1.3.19
1.3.20
1.3.351
1.3.428
1.3.70
1.3.371
  

 

 

MSRS Version 1.3 Known Issues

Version Number Issue Number  Notified Date  N C Details Date of update
1.3 1.3.14892 1st June 2003 1 1 Bug found with stored procedure "pro_sp_GET_UI_script_schemes" - returning null when script scheme name was null.  

Fixed in v1.3 patch A

 27th June 2003
1.3 1.3.14893 1st June 2003 1 1 Bug found with stored procedure "pro_sp_GET_UI_scripts" - returning nulls. 

Fixed in v1.3 patch A

 27th June 2003
1.3 1.3.14894 1st June 2003 1 1 Bug found with stored procedure "pro_sp_load_API_production_bop_static_data_row" due to the changes in the datamodel 

Fixed in v1.3 patch A

 27th June 2003
1.3 1.3.14895 1st June 2003 1 1 Bug found with stored procedure "pro_sp_load_INI_environment_create_jobs" due to the changes in the datamodel 

Fixed in v1.3 patch A

 27th June 2003

Contacting Alignment Systems

To get in touch mail us at enquire@alignment-systems.com

 

 

 

 

 

 

Copyright Information

All product and services names, where appropriate, are trademarks, services marks and / or copyright of their respective owners.  A full list of copyright information can be found here.