Quick Integration Guide

A common way to deliver investment data to Jay is to push daily transaction data and daily position data as CSV-files to Jay’s SFTP Server with PKI authentication. Please follow this quick integration guide for easy integration. There are also other options for integration that are described in section Advanced Integration Options.

Connection

Jay SFTP Server address is: sftp2.jaysolutions.com

Remote directory on Jay SFTP Server is: /inbox

Jay SFTP Server’s public SSH host key is:

CODE

ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQCnDj9OShLdf6LpS8KXSnAoDoov1Qz+l72WaJdOWeez/973v3ginYJ/O3QgCbuWhS7BDNXpagDL7vmQANHCnOZqKrq6DCBjhImGQhfCrzEpR9Mjwn9Uw6zkIdubM0iXrwTI8X8RiTJ5V49rgrU1bTEcqCjffDV8N4hsnco6rL/0HuLDgP0YofuXAreho+MBdtJcQsbckPcVJ+0eTYGhJs04CIsTQ+78Hi1KRKdL81aOVP1Fjwmh8XwQE65yx23FaKBO1LkvRdiLtEKSDYPKA7RXZpSNtaO3qIz9JtaO5rkoOIk8Rvpo6+fcKWxWioXJ2wXqIS66+ewbdSFpr089ORk9

In order to establish the connection, please send us:

Your desired username (preferably company name, alphabets only)
Your OpenSSH Public Key (.pub)
Your SFTP Client Public IP Address, IP Addresses or IP Range

Please send these 3 parameters via encrypted email to it@jaysolutions.com with the title “NEW COUNTERPARTY”. Jay will notify when the server is configured and ready for connection testing with your client software.

Please provide your contact person for connection testing in the email.

Data Content

Please send us two files daily that may include data for multiple customers:

🅣 TRANSACTIONS-YYYYMMDD.CSV

🅟 POSITIONS-YYYYMMDD.CSV

The delivered transactions data is utilized to calculate e.q. daily positions, cash flows and performance at Jay Solutions. The delivered position data is utilized to reconciliate e.q. the quantity of assets daily.

The files should contain information for both investment portfolios and cash accounts. For more detailed field descriptions, see Jay Data Format (v1.11).

🅣 Data fields for transactions

Transaction ID (unique)
Customer ID
Portfolio ID
Cash Account ID
Trade Date
Payment Date
Transaction Type
Security ID
Security Name
Security Currency
FxRate
Quantity
Unit Price in Security Currency
Value in Security Currency
Value in Portfolio Currency
Total Net Value in Security Currency
Total Net Value in Security Currency
BIC
MIC
Brokerage Fee in Security Currency
Other Fee in Security Currency
Accrued Interest in Security Currency
Tax in Security Currency
Tax Type
Additional Info
Trade Reference
Related ID to be Updated or Cancelled
Trader BIC
Counter Portfolio ID
Transaction Subtype

🅟 Data fields for positions

Customer ID
Portfolio ID
Position Date
Security ID
Security Name
Position / Nominal
Unit Price in Security Currency
Market Value in Portfolio Currency
Purchase Value in Portfolio Currency
Market Value on Security Currency
Purchase Value in Security Currency
Security Currency
Cash Account ID
MIC
Accrued Interest in Security Currency
Cash Flow Inbound in Portfolio Currency
Cash Flow Outboud in Portfolio Currency

Your Documentation and Examples

Please send us example file and data format specification for both files.

🅣 Transactions file specification (including transaction type declarations)
🅣 Transaction file example
🅟 Positions file specification
🅟 Positions file example

Please send these 4 files via encrypted email to data@jaysolutions.com with the title “NEW COUNTERPARTY”. Jay might need to ask further questions concerning the specifications and example files.

Please provide a contact person for further questions in email.