Currently, securities are only needed for bond valuation when you have selected a "Market value" approach for the instrument valuation.

 

You can create security quotes manually, bringing API from a data provider, or by using excel import.

 

Excel import for securities

 

Click the first Import tab. From ‘Download sample’ you can get the import excel template that you can use for the import. You can bring 50  at once.

 

Once you have filled in all your accounts and saved the file into your computer, you need to check the file first to make sure  it is readable; and then click ‘import’. Remember to use the date format: yyyy-mm-dd.

 

 

ISIN

It is important that the ISIN code matches exactly the ISIN code in the agreement. This is the link between the agreement and the quote.

 

Date

Date of the quote.

 

Name

It can be a more easily recognisable name of the security.

 

Rate bid

This is the bid side of the security quote of the day. If you are only inserting average rate, you can put both Bid and Ask at the same rate.

 

Rate ask

This is the ask side of the  security quote of the day. If you are only inserting the average rate, you can put both Bid and Ask at the same rate.

 

Rate average

This is the average of the  security quote of the day.