Skip to main content

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!