Skip to content

Instantly share code, notes, and snippets.

@gmananton

gmananton/gist:07a9ce52613badd29ebea263c3d03426

Created July 27, 2020 13:03
Show Gist options
  • Save gmananton/07a9ce52613badd29ebea263c3d03426 to your computer and use it in GitHub Desktop.
Save gmananton/07a9ce52613badd29ebea263c3d03426 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
{
"items":[
{
"mv_bc":"-821.89450483789",
"underlying_id":"USD/RUB",
"position_date":"2020-09-16",
"counterparty_id":"KQX1GD",
"mv":"-58783.054534802",
"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.01398182709868",
"underlying_type":"null",
"position_class":"FORWARD_FX"
},
{
"mv_bc":"807.36557813994",
"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.013941936873204",
"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.013961853441265",
"underlying_type":"null",
"position_class":"FORWARD_FX"
},
{
"mv_bc":"56.780858804134",
"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.013941936873204",
"underlying_type":"null",
"position_class":"FORWARD_CCY"
},
{
"mv_bc":"-1026.7101417749",
"underlying_id":"USD/RUB",
"position_date":"2020-09-09",
"counterparty_id":"KQX1GD",
"mv":"-73431.757847431",
"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.01398182709868",
"underlying_type":"null",
"position_class":"FORWARD_FX"
},
{
"mv_bc":"996.90663099536",
"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.013941936873204",
"underlying_type":"null",
"position_class":"FORWARD_CCY"
},
{
"mv_bc":"48.831353701943",
"underlying_id":"USD/RUB",
"position_date":"2020-08-04",
"counterparty_id":"KQX1GD",
"mv":"3502.4799026162",
"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.013941936873204",
"underlying_type":"null",
"position_class":"FORWARD_FX"
},
{
"mv_bc":"-48.858037474836",
"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.01398182709868",
"underlying_type":"null",
"position_class":"FORWARD_CCY"
},
{
"mv_bc":"-1026.8023471423",
"underlying_id":"USD/RUB",
"position_date":"2020-09-10",
"counterparty_id":"KQX1GD",
"mv":"-73438.352505391",
"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.01398182709868",
"underlying_type":"null",
"position_class":"FORWARD_FX"
},
{
"mv_bc":"996.79766311522",
"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.013941936873204",
"underlying_type":"null",
"position_class":"FORWARD_CCY"
},
{
"mv_bc":"99.645632537034",
"underlying_id":"USD/RUB",
"position_date":"2020-08-03",
"counterparty_id":"KQX1GD",
"mv":"7147.1871837654",
"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.013941936873204",
"underlying_type":"null",
"position_class":"FORWARD_FX"
},
{
"mv_bc":"-99.755578789849",
"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.01398182709868",
"underlying_type":"null",
"position_class":"FORWARD_CCY"
},
{
"mv_bc":"19418.95933586",
"underlying_id":"USD/RUB",
"position_date":"2020-07-31",
"counterparty_id":"KQX1GD",
"mv":"1392845.1629402",
"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.013941936873204",
"underlying_type":"null",
"position_class":"FORWARD_FX"
},
{
"mv_bc":"-19465.987041937",
"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.01398182709868",
"underlying_type":"null",
"position_class":"FORWARD_CCY"
},
{
"mv_bc":"-1046.2317477772",
"underlying_id":"USD/RUB",
"position_date":"2020-11-11",
"counterparty_id":"KQX1GD",
"mv":"-74824.623040494",
"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.01398245263743",
"underlying_type":"null",
"position_class":"FORWARD_FX"
},
{
"mv_bc":"990.27468432617",
"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.013942558844645",
"underlying_type":"null",
"position_class":"FORWARD_CCY"
},
{
"mv_bc":"-157520.82973255",
"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.01398245263743",
"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