Importing Prices & FX Rates

Try to get Prices from Exante

Go to /explorer/workflows/com/finmars/exante-broker/get-prices/test.ipynb

Configure your Test Script

Screenshot 2024-09-25 at 23.59.52.png

So you need to have Instrument Reference and date period (date_from and date_to)

Try to execute it!

 

Screenshot 2024-09-26 at 00.00.58.png


This is how you could get prices from Exante, probably you will need close price

FX Rate Situation from Exante

Currently there is no way to get Historical End Of Day FX Rates from Exante

You could refer to https://api-live.exante.eu/api-docs/#tag/Crossrates-API

But Its some rate during the day of the request

Download Prices to Finmars

Go to Workflow Page
Screenshot 2024-09-28 at 21.51.01.png

Execute workflow com.finmars.exante-broker:get-prices

Screenshot 2024-09-28 at 21.54.54.png

Go to see status of your workflow

Screenshot 2024-09-28 at 21.55.24.png

Great success! You can find your downloaded instrument in /explorer/data/exante/prices

Screenshot 2024-09-28 at 21.55.51.png


See content of month folder, it should has list of .json files with actual prices from Exante

Screenshot 2024-09-28 at 21.56.22.png


Example of content: 

[
    {
        "close": "2.925",
        "high": "2.985",
        "low": "2.865",
        "open": "2.94",
        "timestamp": 1726790400000,
        "date": "2024-09-20",
        "instrument": "CIFR.NASDAQ"
    }
]


Now see com.finmars.exante-data-transformer, it should have Price transformer to Finmars Standard Configuration 

Transform Prices to Standard Configuration

Precondition: You downloaded some Positions from Exante (Check your /explorer/data/exante/prices folder)

Go to Worfklow Page

Screenshot 2024-09-28 at 22.14.30.png

 

Execute com.finmars.exante-data-transformer:transform-prices 
Example Payload

{
  "date_from": "2024-09-01",
  "date_to": "2024-09-20",
  "instruments": [
    "CIFR.NASDAQ"
  ]
}


Screenshot 2024-09-28 at 22.15.26.png

Check you Task status


Screenshot 2024-09-28 at 22.16.01.png

Great work! Now you can see your converted prices in /explorer/data/general/prices

Screenshot 2024-09-28 at 22.16.40.png

Content Example:

[
    {
        "date": "2024-09-03",
        "instrument": "US17253J1060",
        "principal_price": 3.13,
        "factor": 1,
        "accured_price": 0,
        "prc_pol": null
    },
    {
        "date": "2024-09-04",
        "instrument": "US17253J1060",
        "principal_price": 3.015,
        "factor": 1,
        "accured_price": 0,
        "prc_pol": null
    }
]

Well done! This file will go to STD - Prices (com.finmars.standard-import-from-file:instruments.pricehistory:price)

You can try manually import that data in Finmars (do not forget wrap Dictionary into List - Square Brackets [] )



Screenshot 2024-09-28 at 22.18.00.png

Well done!

Screenshot 2024-09-28 at 22.18.26.png

Now go to Valuation - Prices (Entity Viewer)

Screenshot 2024-09-28 at 22.18.58.png

Prices is successfully imported into Finmars!

After that you should able to see valuation

Screenshot 2024-09-28 at 22.20.04.png

Great success! Well done!