Skip to content

Instantly share code, notes, and snippets.

@gmananton

gmananton/gist:3f83c1962d8733834ac19591723f2506

Created July 27, 2020 13:04
Show Gist options
  • Save gmananton/3f83c1962d8733834ac19591723f2506 to your computer and use it in GitHub Desktop.
Save gmananton/3f83c1962d8733834ac19591723f2506 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
{
"items":[
{
"mv_bc":"-821.88518907809",
"underlying_id":"USD/RUB",
"position_date":"2020-09-16",
"counterparty_id":"KQX1GD",
"mv":"-58783.374422997",
"reference_instrument_id":"USD/RUB",
"book_id":"D04 FWD Online",
"ag_grid_key":"KQX1GD2020-09-16USD/RUBUSD/RUBD04 FWD OnlineFORWARDFORWARD_FX",
"position_ccy_id":"USD",
"ccy_of_mv":"RUB",
"report_currency_bc":"USD",
"position_quantity":"-800",
"create_date":"2020-07-27",
"position_type":"FORWARD",
"conversion_rate":"0.013981592536079",
"underlying_type":"null",
"position_class":"FORWARD_FX"
},
{
"mv_bc":"807.35207228164",
"underlying_id":"RUB",
"position_date":"2020-09-16",
"counterparty_id":"KQX1GD",
"mv":"57909.140278181",
"reference_instrument_id":"USD/RUB",
"book_id":"D04 FWD Online",
"ag_grid_key":"KQX1GD2020-09-16RUBUSD/RUBD04 FWD OnlineFORWARDFORWARD_CCY",
"position_ccy_id":"RUB",
"ccy_of_mv":"RUB",
"report_currency_bc":"USD",
"position_quantity":"58233.76",
"create_date":"2020-07-27",
"position_type":"FORWARD",
"conversion_rate":"0.013941703648221",
"underlying_type":"null",
"position_class":"FORWARD_CCY"
},
{
"mv_bc":"-1026.8018939898",
"underlying_id":"USD/RUB",
"position_date":"2020-09-10",
"counterparty_id":"KQX1GD",
"mv":"-73439.55213544",
"reference_instrument_id":"USD/RUB",
"book_id":"D04 FWD Online",
"ag_grid_key":"KQX1GD2020-09-10USD/RUBUSD/RUBD04 FWD OnlineFORWARDFORWARD_FX",
"position_ccy_id":"USD",
"ccy_of_mv":"RUB",
"report_currency_bc":"USD",
"position_quantity":"-1000",
"create_date":"2020-07-27",
"position_type":"FORWARD",
"conversion_rate":"0.013981592536079",
"underlying_type":"null",
"position_class":"FORWARD_FX"
},
{
"mv_bc":"996.78098837906",
"underlying_id":"RUB",
"position_date":"2020-09-10",
"counterparty_id":"KQX1GD",
"mv":"71496.35464431",
"reference_instrument_id":"USD/RUB",
"book_id":"D04 FWD Online",
"ag_grid_key":"KQX1GD2020-09-10RUBUSD/RUBD04 FWD OnlineFORWARDFORWARD_CCY",
"position_ccy_id":"RUB",
"ccy_of_mv":"RUB",
"report_currency_bc":"USD",
"position_quantity":"71850",
"create_date":"2020-07-27",
"position_type":"FORWARD",
"conversion_rate":"0.013941703648221",
"underlying_type":"null",
"position_class":"FORWARD_CCY"
},
{
"mv_bc":"0",
"underlying_id":"USD/RUB",
"position_date":"2020-07-30",
"counterparty_id":"KQX1GD",
"mv":"0",
"reference_instrument_id":"USD/RUB",
"book_id":"D04 FWD Online",
"ag_grid_key":"KQX1GD2020-07-30USD/RUBUSD/RUBD04 FWD OnlineFORWARDFORWARD_FX",
"position_ccy_id":"USD",
"ccy_of_mv":"RUB",
"report_currency_bc":"USD",
"position_quantity":"0",
"create_date":"2020-07-27",
"position_type":"FORWARD",
"conversion_rate":"0.013961619548907",
"underlying_type":"null",
"position_class":"FORWARD_FX"
},
{
"mv_bc":"56.779908956563",
"underlying_id":"RUB",
"position_date":"2020-07-30",
"counterparty_id":"KQX1GD",
"mv":"4072.6664681192",
"reference_instrument_id":"USD/RUB",
"book_id":"D04 FWD Online",
"ag_grid_key":"KQX1GD2020-07-30RUBUSD/RUBD04 FWD OnlineFORWARDFORWARD_CCY",
"position_ccy_id":"RUB",
"ccy_of_mv":"RUB",
"report_currency_bc":"USD",
"position_quantity":"4074",
"create_date":"2020-07-27",
"position_type":"FORWARD",
"conversion_rate":"0.013941703648221",
"underlying_type":"null",
"position_class":"FORWARD_CCY"
},
{
"mv_bc":"-1026.7096902842",
"underlying_id":"USD/RUB",
"position_date":"2020-09-09",
"counterparty_id":"KQX1GD",
"mv":"-73432.957485699",
"reference_instrument_id":"USD/RUB",
"book_id":"D04 FWD Online",
"ag_grid_key":"KQX1GD2020-09-09USD/RUBUSD/RUBD04 FWD OnlineFORWARDFORWARD_FX",
"position_ccy_id":"USD",
"ccy_of_mv":"RUB",
"report_currency_bc":"USD",
"position_quantity":"-1000",
"create_date":"2020-07-27",
"position_type":"FORWARD",
"conversion_rate":"0.013981592536079",
"underlying_type":"null",
"position_class":"FORWARD_FX"
},
{
"mv_bc":"996.88995443636",
"underlying_id":"RUB",
"position_date":"2020-09-09",
"counterparty_id":"KQX1GD",
"mv":"71504.170479451",
"reference_instrument_id":"USD/RUB",
"book_id":"D04 FWD Online",
"ag_grid_key":"KQX1GD2020-09-09RUBUSD/RUBD04 FWD OnlineFORWARDFORWARD_CCY",
"position_ccy_id":"RUB",
"ccy_of_mv":"RUB",
"report_currency_bc":"USD",
"position_quantity":"71850",
"create_date":"2020-07-27",
"position_type":"FORWARD",
"conversion_rate":"0.013941703648221",
"underlying_type":"null",
"position_class":"FORWARD_CCY"
},
{
"mv_bc":"48.831356563363",
"underlying_id":"USD/RUB",
"position_date":"2020-08-04",
"counterparty_id":"KQX1GD",
"mv":"3502.5386993931",
"reference_instrument_id":"USD/RUB",
"book_id":"D04 FWD Online",
"ag_grid_key":"KQX1GD2020-08-04USD/RUBUSD/RUBD04 FWD OnlineFORWARDFORWARD_FX",
"position_ccy_id":"USD",
"ccy_of_mv":"RUB",
"report_currency_bc":"USD",
"position_quantity":"49",
"create_date":"2020-07-27",
"position_type":"FORWARD",
"conversion_rate":"0.013941703648221",
"underlying_type":"null",
"position_class":"FORWARD_FX"
},
{
"mv_bc":"-48.857217820273",
"underlying_id":"RUB",
"position_date":"2020-08-04",
"counterparty_id":"KQX1GD",
"mv":"-3494.3957703102",
"reference_instrument_id":"USD/RUB",
"book_id":"D04 FWD Online",
"ag_grid_key":"KQX1GD2020-08-04RUBUSD/RUBD04 FWD OnlineFORWARDFORWARD_CCY",
"position_ccy_id":"RUB",
"ccy_of_mv":"RUB",
"report_currency_bc":"USD",
"position_quantity":"-3497.4",
"create_date":"2020-07-27",
"position_type":"FORWARD",
"conversion_rate":"0.013981592536079",
"underlying_type":"null",
"position_class":"FORWARD_CCY"
},
{
"mv_bc":"-1046.2288654322",
"underlying_id":"USD/RUB",
"position_date":"2020-11-11",
"counterparty_id":"KQX1GD",
"mv":"-74829.019851096",
"reference_instrument_id":"USD/RUB",
"book_id":"D04 FWD Online",
"ag_grid_key":"KQX1GD2020-11-11USD/RUBUSD/RUBD04 FWD OnlineFORWARDFORWARD_FX",
"position_ccy_id":"USD",
"ccy_of_mv":"RUB",
"report_currency_bc":"USD",
"position_quantity":"-1000",
"create_date":"2020-07-27",
"position_type":"FORWARD",
"conversion_rate":"0.013981592536079",
"underlying_type":"null",
"position_class":"FORWARD_FX"
},
{
"mv_bc":"990.21394372767",
"underlying_id":"RUB",
"position_date":"2020-11-11",
"counterparty_id":"KQX1GD",
"mv":"71025.318620515",
"reference_instrument_id":"USD/RUB",
"book_id":"D04 FWD Online",
"ag_grid_key":"KQX1GD2020-11-11RUBUSD/RUBD04 FWD OnlineFORWARDFORWARD_CCY",
"position_ccy_id":"RUB",
"ccy_of_mv":"RUB",
"report_currency_bc":"USD",
"position_quantity":"71850",
"create_date":"2020-07-27",
"position_type":"FORWARD",
"conversion_rate":"0.013941703648221",
"underlying_type":"null",
"position_class":"FORWARD_CCY"
},
{
"mv_bc":"99.645638558614",
"underlying_id":"USD/RUB",
"position_date":"2020-08-03",
"counterparty_id":"KQX1GD",
"mv":"7147.3071780099",
"reference_instrument_id":"USD/RUB",
"book_id":"D04 FWD Online",
"ag_grid_key":"KQX1GD2020-08-03USD/RUBUSD/RUBD04 FWD OnlineFORWARDFORWARD_FX",
"position_ccy_id":"USD",
"ccy_of_mv":"RUB",
"report_currency_bc":"USD",
"position_quantity":"100",
"create_date":"2020-07-27",
"position_type":"FORWARD",
"conversion_rate":"0.013941703648221",
"underlying_type":"null",
"position_class":"FORWARD_FX"
},
{
"mv_bc":"-99.753905265501",
"underlying_id":"RUB",
"position_date":"2020-08-03",
"counterparty_id":"KQX1GD",
"mv":"-7134.6597326515",
"reference_instrument_id":"USD/RUB",
"book_id":"D04 FWD Online",
"ag_grid_key":"KQX1GD2020-08-03RUBUSD/RUBD04 FWD OnlineFORWARDFORWARD_CCY",
"position_ccy_id":"RUB",
"ccy_of_mv":"RUB",
"report_currency_bc":"USD",
"position_quantity":"-7140.03",
"create_date":"2020-07-27",
"position_type":"FORWARD",
"conversion_rate":"0.013981592536079",
"underlying_type":"null",
"position_class":"FORWARD_CCY"
},
{
"mv_bc":"19418.960616116",
"underlying_id":"USD/RUB",
"position_date":"2020-07-31",
"counterparty_id":"KQX1GD",
"mv":"1392868.555099",
"reference_instrument_id":"USD/RUB",
"book_id":"D04 FWD Online",
"ag_grid_key":"KQX1GD2020-07-31USD/RUBUSD/RUBD04 FWD OnlineFORWARDFORWARD_FX",
"position_ccy_id":"USD",
"ccy_of_mv":"RUB",
"report_currency_bc":"USD",
"position_quantity":"19494",
"create_date":"2020-07-27",
"position_type":"FORWARD",
"conversion_rate":"0.013941703648221",
"underlying_type":"null",
"position_class":"FORWARD_FX"
},
{
"mv_bc":"-19465.660475707",
"underlying_id":"RUB",
"position_date":"2020-07-31",
"counterparty_id":"KQX1GD",
"mv":"-1392234.8563282",
"reference_instrument_id":"USD/RUB",
"book_id":"D04 FWD Online",
"ag_grid_key":"KQX1GD2020-07-31RUBUSD/RUBD04 FWD OnlineFORWARDFORWARD_CCY",
"position_ccy_id":"RUB",
"ccy_of_mv":"RUB",
"report_currency_bc":"USD",
"position_quantity":"-1392835.87",
"create_date":"2020-07-27",
"position_type":"FORWARD",
"conversion_rate":"0.013981592536079",
"underlying_type":"null",
"position_class":"FORWARD_CCY"
},
{
"mv_bc":"-157511.14016792",
"underlying_id":"RUB",
"position_date":"null",
"counterparty_id":"KQX1GD",
"mv":"-1.126560796E7",
"reference_instrument_id":"USD/RUB",
"book_id":"D04 FWD Online",
"ag_grid_key":"KQX1GDNONERUBUSD/RUBD04 FWD OnlineCASHACTIVE_CASH",
"position_ccy_id":"RUB",
"ccy_of_mv":"RUB",
"report_currency_bc":"USD",
"position_quantity":"-1.126560796E7",
"create_date":"2020-07-27",
"position_type":"CASH",
"conversion_rate":"0.013981592536079",
"underlying_type":"null",
"position_class":"ACTIVE_CASH"
},
{
"mv_bc":"143792.62",
"underlying_id":"USD",
"position_date":"null",
"counterparty_id":"KQX1GD",
"mv":"143792.62",
"reference_instrument_id":"USD/RUB",
"book_id":"D04 FWD Online",
"ag_grid_key":"KQX1GDNONEUSDUSD/RUBD04 FWD OnlineCASHACTIVE_CASH",
"position_ccy_id":"USD",
"ccy_of_mv":"USD",
"report_currency_bc":"USD",
"position_quantity":"143792.62",
"create_date":"2020-07-27",
"position_type":"CASH",
"conversion_rate":"1",
"underlying_type":"null",
"position_class":"ACTIVE_CASH"
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment