Skip to main content

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