Daily Import Introduction

What is Daily Import? Its a pipeline that covers all workflows and schedules that runs in background to import all the data into your Space in Finmars Daily Import could be different from client to client, from provider to provider, but as core concept it should have these essential steps: 

 

 Daily Positions Import

 

 Download Positions  

 Transform Postions to Standard Format 

 Parse Positions to find new Instruments/Currencies 

 Import new Instruments/Currencies 

 Import Positions 

 

 

 Daily Transactions Import

 

 Download Transactions 

 Transform Transactions to Standard Format 

 Import Transactions 

 

 

 Valuations Import

 

 Download Prices 

 Transform Prices to Standard Format 

 Import Prices 

 Download FX Rates 

 Transform FX Rates to Standard Format 

 Import FX Rates 

 

 

 

 Thats a Basic ETL flow that should be applied on Daily Basis