Skip to content

Instantly share code, notes, and snippets.

@tsotetsi

tsotetsi/data

Created August 28, 2020 12:28
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save tsotetsi/611e06c93fd7b9e51f57fe70ebda84c9 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save tsotetsi/611e06c93fd7b9e51f57fe70ebda84c9 to your computer and use it in GitHub Desktop.
Download ZIP
data-file
Raw
data
{
"mancoName": "Sanlam Collective Investments",
"mancoEntityNumber": 0,
"portfolio": {
"currencyCode": "ZAR",
"currencySymbol": "R",
"entityNumber": 351032109,
"mancoEntityNumber": 0,
"mancoName": "Sanlam Collective Investments",
"totalMarketValue": 0,
"clientAccountGroups": [
{
"productId": "SCIRSA",
"accountGroupId": "SCI",
"allocationPercentage": 100,
"portfolioManagerBrandCode": "sanlam",
"availableMarketValue": 249060.083283,
"brandLabel": "Sanlam",
"brokerageName": "SANLAM COLLECTIVE INVESTMENTS BU",
"brokerageNumber": 2000024,
"brokerFeePercentage": 0,
"brokerName": "SCI DIRECT BUSINESS",
"brokerNumber": 152500000,
"brokerTrailerFeePercenge": 0,
"clientAccountGroupNumber": 90020163,
"currencyCode": "ZAR",
"currencySymbol": "R",
"inceptionDate": "2015-09-24",
"updatedDate": "2015-09-24",
"isActive": true,
"marketValue": 249060.08328328,
"productCode": "ut",
"productName": null,
"productLabel": "Unit Trust",
"showLabel": false,
"showLogo": true,
"status": "Open",
"percentageComplete": 100,
"valueDate": "2018-09-01",
"funds": [
{
"availableMarketValue": 0,
"availableUnits": 0,
"brokerName": "SCI DIRECT BUSINESS",
"brokerNumber": 152500000,
"clientAccountNumber": 1293875,
"currencyCode": "ZAR",
"currencySymbol": null,
"debitOrderCurrentAmount": 0,
"fund": {
"currencyCode": "ZAR",
"currencySymbol": null,
"cutOffTime": null,
"endDate": null,
"fundName": "SIM MONEY MARKET FUND R",
"fundNumber": 470,
"jseCode": "SNMM",
"launchDate": null,
"mancoNumber": 0,
"maxDebitOrderAmount": null,
"maxLumpSumAmount": null,
"minDebitOrderAmount": null,
"minLumpSumAmount": null,
"minWithdrawalAmount": null,
"unitPrice": 100
},
"hasRecurringDebitOrder": false,
"initialFee": 0,
"isActive": false,
"marketValue": 0,
"pendingUnits": 0,
"pendingValue": 0,
"startDate": "2017-06-18",
"totalUnits": 0,
"transactableUnits": 0,
"transactableValue": 0,
"unclearedUnits": 0,
"unitPrice": 100,
"unitPriceDate": "2018-09-01"
},
{
"availableMarketValue": 21736.595794,
"availableUnits": 1998.5469,
"brokerName": "SCI DIRECT BUSINESS",
"brokerNumber": 152500000,
"clientAccountNumber": 1379973,
"currencyCode": "ZAR",
"currencySymbol": null,
"debitOrderCurrentAmount": 0,
"fund": {
"currencyCode": "ZAR",
"currencySymbol": null,
"cutOffTime": null,
"endDate": null,
"fundName": "DENKER SCI EMERGING MARKETS FEEDER FUND B1",
"fundNumber": 860,
"jseCode": "SFFB1",
"launchDate": null,
"mancoNumber": 0,
"maxDebitOrderAmount": null,
"maxLumpSumAmount": null,
"minDebitOrderAmount": null,
"minLumpSumAmount": null,
"minWithdrawalAmount": null,
"unitPrice": 1087.62
},
"hasRecurringDebitOrder": false,
"initialFee": 0,
"isActive": true,
"marketValue": 21736.59579378,
"pendingUnits": 0,
"pendingValue": 0,
"startDate": "2017-12-07",
"totalUnits": 1998.5469,
"transactableUnits": 1998.5469,
"transactableValue": 21736.59579378,
"unclearedUnits": 0,
"unitPrice": 1087.62,
"unitPriceDate": "2018-08-31"
},
{
"availableMarketValue": 74217.403129,
"availableUnits": 2363.9127,
"brokerName": "SCI DIRECT BUSINESS",
"brokerNumber": 152500000,
"clientAccountNumber": 1293345,
"currencyCode": "ZAR",
"currencySymbol": null,
"debitOrderCurrentAmount": 0,
"fund": {
"currencyCode": "ZAR",
"currencySymbol": null,
"cutOffTime": null,
"endDate": null,
"fundName": "DENKER SCI GLOBAL FINANCIAL FEEDER FUND B1",
"fundNumber": 53,
"jseCode": "SGFFB1",
"launchDate": null,
"mancoNumber": 0,
"maxDebitOrderAmount": null,
"maxLumpSumAmount": null,
"minDebitOrderAmount": null,
"minLumpSumAmount": null,
"minWithdrawalAmount": null,
"unitPrice": 3139.6
},
"hasRecurringDebitOrder": false,
"initialFee": 0,
"isActive": true,
"marketValue": 74217.4031292,
"pendingUnits": 0,
"pendingValue": 0,
"startDate": "2017-06-09",
"totalUnits": 2363.9127,
"transactableUnits": 2363.9127,
"transactableValue": 74217.4031292,
"unclearedUnits": 0,
"unitPrice": 3139.6,
"unitPriceDate": "2018-08-31"
},
{
"availableMarketValue": 91786.948524,
"availableUnits": 464.0502,
"brokerName": "SCI DIRECT BUSINESS",
"brokerNumber": 152500000,
"clientAccountNumber": 1367016,
"currencyCode": "ZAR",
"currencySymbol": null,
"debitOrderCurrentAmount": 0,
"fund": {
"currencyCode": "ZAR",
"currencySymbol": null,
"cutOffTime": null,
"endDate": null,
"fundName": "SIM INDUSTRIAL FUND B2",
"fundNumber": 88,
"jseCode": "SAIB2",
"launchDate": null,
"mancoNumber": 0,
"maxDebitOrderAmount": null,
"maxLumpSumAmount": null,
"minDebitOrderAmount": null,
"minLumpSumAmount": null,
"minWithdrawalAmount": null,
"unitPrice": 19779.53
},
"hasRecurringDebitOrder": false,
"initialFee": 0,
"isActive": true,
"marketValue": 91786.94852406,
"pendingUnits": 0,
"pendingValue": 0,
"startDate": "2017-07-09",
"totalUnits": 464.0502,
"transactableUnits": 464.0502,
"transactableValue": 91786.94852406,
"unclearedUnits": 0,
"unitPrice": 19779.53,
"unitPriceDate": "2018-08-31"
},
{
"availableMarketValue": 0,
"availableUnits": 0,
"brokerName": "SCI DIRECT BUSINESS",
"brokerNumber": 152500000,
"clientAccountNumber": 1295015,
"currencyCode": "ZAR",
"currencySymbol": null,
"debitOrderCurrentAmount": 0,
"fund": {
"currencyCode": "ZAR",
"currencySymbol": null,
"cutOffTime": null,
"endDate": null,
"fundName": "SIM INDUSTRIAL FUND A",
"fundNumber": 353,
"jseCode": "SIFA",
"launchDate": null,
"mancoNumber": 0,
"maxDebitOrderAmount": null,
"maxLumpSumAmount": null,
"minDebitOrderAmount": null,
"minLumpSumAmount": null,
"minWithdrawalAmount": null,
"unitPrice": 19590.14
},
"hasRecurringDebitOrder": false,
"initialFee": 0,
"isActive": false,
"marketValue": 0,
"pendingUnits": 0,
"pendingValue": 0,
"startDate": "2017-07-05",
"totalUnits": 0,
"transactableUnits": 0,
"transactableValue": 0,
"unclearedUnits": 0,
"unitPrice": 19590.14,
"unitPriceDate": "2018-08-31"
},
{
"availableMarketValue": 61319.135836,
"availableUnits": 2493.6412,
"brokerName": "SCI DIRECT BUSINESS",
"brokerNumber": 152500000,
"clientAccountNumber": 1293341,
"currencyCode": "ZAR",
"currencySymbol": null,
"debitOrderCurrentAmount": 0,
"fund": {
"currencyCode": "ZAR",
"currencySymbol": null,
"cutOffTime": null,
"endDate": null,
"fundName": "SANLAM INDIA OPPORTUNITIES FEEDER FUND",
"fundNumber": 346,
"jseCode": "SNFF",
"launchDate": null,
"mancoNumber": 0,
"maxDebitOrderAmount": null,
"maxLumpSumAmount": null,
"minDebitOrderAmount": null,
"minLumpSumAmount": null,
"minWithdrawalAmount": null,
"unitPrice": 2459.02
},
"hasRecurringDebitOrder": false,
"initialFee": 0,
"isActive": true,
"marketValue": 61319.13583624,
"pendingUnits": 0,
"pendingValue": 0,
"startDate": "2017-06-09",
"totalUnits": 2493.6412,
"transactableUnits": 2493.6412,
"transactableValue": 61319.13583624,
"unclearedUnits": 0,
"unitPrice": 2459.02,
"unitPriceDate": "2018-08-31"
}
]
},
{
"productId": "TFSA",
"accountGroupId": "TFSA",
"allocationPercentage": 100,
"portfolioManagerBrandCode": "satrix",
"availableMarketValue": 64165.2789,
"brandLabel": "Sanlam",
"brokerageName": "SANLAM COLLECTIVE INVESTMENTS BU",
"brokerageNumber": 2000024,
"brokerFeePercentage": 0,
"brokerName": "SCI DIRECT SPECIAL FEES",
"brokerNumber": 102000000,
"brokerTrailerFeePercenge": 0,
"clientAccountGroupNumber": 90020342,
"currencyCode": "ZAR",
"currencySymbol": "R",
"inceptionDate": "2017-06-18",
"updatedDate": "2017-06-18",
"isActive": true,
"marketValue": 64165.27889953,
"productCode": "tfsa",
"productName": null,
"productLabel": "Tax Free Savings Account",
"showLabel": false,
"showLogo": true,
"status": "Pending",
"percentageComplete": 100,
"valueDate": "2018-08-31",
"funds": [
{
"availableMarketValue": 0,
"availableUnits": 0,
"brokerName": "SCI DIRECT SPECIAL FEES",
"brokerNumber": 102000000,
"clientAccountNumber": 1411006,
"currencyCode": "ZAR",
"currencySymbol": null,
"debitOrderCurrentAmount": 0,
"fund": {
"currencyCode": "ZAR",
"currencySymbol": null,
"cutOffTime": null,
"endDate": null,
"fundName": "SIM GENERAL EQUITY FUND A1",
"fundNumber": 564,
"jseCode": "SEFA1",
"launchDate": null,
"mancoNumber": 0,
"maxDebitOrderAmount": null,
"maxLumpSumAmount": null,
"minDebitOrderAmount": null,
"minLumpSumAmount": null,
"minWithdrawalAmount": null,
"unitPrice": 22272.09
},
"hasRecurringDebitOrder": false,
"initialFee": 0,
"isActive": false,
"marketValue": 0,
"pendingUnits": 0,
"pendingValue": 0,
"startDate": "2018-04-13",
"totalUnits": 0,
"transactableUnits": 0,
"transactableValue": 0,
"unclearedUnits": 0,
"unitPrice": 22272.09,
"unitPriceDate": "2018-08-31"
},
{
"availableMarketValue": 0,
"availableUnits": 0,
"brokerName": "SCI DIRECT SPECIAL FEES",
"brokerNumber": 102000000,
"clientAccountNumber": 1293876,
"currencyCode": "ZAR",
"currencySymbol": null,
"debitOrderCurrentAmount": 0,
"fund": {
"currencyCode": "ZAR",
"currencySymbol": null,
"cutOffTime": null,
"endDate": null,
"fundName": "DENKER SCI EMERGING MARKETS FEEDER FUND A1",
"fundNumber": 858,
"jseCode": "SGFA1",
"launchDate": null,
"mancoNumber": 0,
"maxDebitOrderAmount": null,
"maxLumpSumAmount": null,
"minDebitOrderAmount": null,
"minLumpSumAmount": null,
"minWithdrawalAmount": null,
"unitPrice": 1082.44
},
"hasRecurringDebitOrder": false,
"initialFee": 0,
"isActive": false,
"marketValue": 0,
"pendingUnits": 0,
"pendingValue": 0,
"startDate": "2017-06-19",
"totalUnits": 0,
"transactableUnits": 0,
"transactableValue": 0,
"unclearedUnits": 0,
"unitPrice": 1082.44,
"unitPriceDate": "2018-08-31"
},
{
"availableMarketValue": 29581.149667,
"availableUnits": 2719.8056,
"brokerName": "SCI DIRECT SPECIAL FEES",
"brokerNumber": 102000000,
"clientAccountNumber": 1293874,
"currencyCode": "ZAR",
"currencySymbol": null,
"debitOrderCurrentAmount": 0,
"fund": {
"currencyCode": "ZAR",
"currencySymbol": null,
"cutOffTime": null,
"endDate": null,
"fundName": "DENKER SCI EMERGING MARKETS FEEDER FUND B1",
"fundNumber": 860,
"jseCode": "SFFB1",
"launchDate": null,
"mancoNumber": 0,
"maxDebitOrderAmount": null,
"maxLumpSumAmount": null,
"minDebitOrderAmount": null,
"minLumpSumAmount": null,
"minWithdrawalAmount": null,
"unitPrice": 1087.62
},
"hasRecurringDebitOrder": false,
"initialFee": 0,
"isActive": true,
"marketValue": 29581.14966672,
"pendingUnits": 0,
"pendingValue": 0,
"startDate": "2017-06-18",
"totalUnits": 2719.8056,
"transactableUnits": 2719.8056,
"transactableValue": 29581.14966672,
"unclearedUnits": 0,
"unitPrice": 1087.62,
"unitPriceDate": "2018-08-31"
},
{
"availableMarketValue": 34584.129233,
"availableUnits": 155.1031,
"brokerName": "SCI DIRECT SPECIAL FEES",
"brokerNumber": 102000000,
"clientAccountNumber": 1411734,
"currencyCode": "ZAR",
"currencySymbol": null,
"debitOrderCurrentAmount": 0,
"fund": {
"currencyCode": "ZAR",
"currencySymbol": null,
"cutOffTime": null,
"endDate": null,
"fundName": "SIM GENERAL EQUITY FUND B8",
"fundNumber": 569,
"jseCode": "SGEB8",
"launchDate": null,
"mancoNumber": 0,
"maxDebitOrderAmount": null,
"maxLumpSumAmount": null,
"minDebitOrderAmount": null,
"minLumpSumAmount": null,
"minWithdrawalAmount": null,
"unitPrice": 22297.51
},
"hasRecurringDebitOrder": false,
"initialFee": 0,
"isActive": true,
"marketValue": 34584.12923281,
"pendingUnits": 0,
"pendingValue": 0,
"startDate": "2018-04-26",
"totalUnits": 155.1031,
"transactableUnits": 155.1031,
"transactableValue": 34584.12923281,
"unclearedUnits": 0,
"unitPrice": 22297.51,
"unitPriceDate": "2018-08-31"
}
]
},
{
"productId": "TFSA",
"accountGroupId": "TFSA",
"allocationPercentage": 100,
"portfolioManagerBrandCode": "sanlam",
"availableMarketValue": 64165.2789,
"brandLabel": "Sanlam",
"brokerageName": "SANLAM COLLECTIVE INVESTMENTS BU",
"brokerageNumber": 2000024,
"brokerFeePercentage": 0,
"brokerName": "SCI DIRECT SPECIAL FEES",
"brokerNumber": 102000000,
"brokerTrailerFeePercenge": 0,
"clientAccountGroupNumber": 90020342,
"currencyCode": "ZAR",
"currencySymbol": "R",
"inceptionDate": null,
"updatedDate": "2018-08-31",
"isActive": true,
"marketValue": 64165.27889953,
"productCode": "tfsa",
"productName": null,
"productLabel": "Tax Free Savings Account",
"showLabel": false,
"showLogo": true,
"status": "Incomplete",
"percentageComplete": 35,
"valueDate": "2018-08-31",
"funds": [
{
"availableMarketValue": 0,
"availableUnits": 0,
"brokerName": "SCI DIRECT SPECIAL FEES",
"brokerNumber": 102000000,
"clientAccountNumber": 1411006,
"currencyCode": "ZAR",
"currencySymbol": null,
"debitOrderCurrentAmount": 0,
"fund": {
"currencyCode": "ZAR",
"currencySymbol": null,
"cutOffTime": null,
"endDate": null,
"fundName": "SIM GENERAL EQUITY FUND A1",
"fundNumber": 564,
"jseCode": "SEFA1",
"launchDate": null,
"mancoNumber": 0,
"maxDebitOrderAmount": null,
"maxLumpSumAmount": null,
"minDebitOrderAmount": null,
"minLumpSumAmount": null,
"minWithdrawalAmount": null,
"unitPrice": 22272.09
},
"hasRecurringDebitOrder": false,
"initialFee": 0,
"isActive": false,
"marketValue": 0,
"pendingUnits": 0,
"pendingValue": 0,
"startDate": "2018-04-13",
"totalUnits": 0,
"transactableUnits": 0,
"transactableValue": 0,
"unclearedUnits": 0,
"unitPrice": 22272.09,
"unitPriceDate": "2018-08-31"
},
{
"availableMarketValue": 0,
"availableUnits": 0,
"brokerName": "SCI DIRECT SPECIAL FEES",
"brokerNumber": 102000000,
"clientAccountNumber": 1293876,
"currencyCode": "ZAR",
"currencySymbol": null,
"debitOrderCurrentAmount": 0,
"fund": {
"currencyCode": "ZAR",
"currencySymbol": null,
"cutOffTime": null,
"endDate": null,
"fundName": "DENKER SCI EMERGING MARKETS FEEDER FUND A1",
"fundNumber": 858,
"jseCode": "SGFA1",
"launchDate": null,
"mancoNumber": 0,
"maxDebitOrderAmount": null,
"maxLumpSumAmount": null,
"minDebitOrderAmount": null,
"minLumpSumAmount": null,
"minWithdrawalAmount": null,
"unitPrice": 1082.44
},
"hasRecurringDebitOrder": false,
"initialFee": 0,
"isActive": false,
"marketValue": 0,
"pendingUnits": 0,
"pendingValue": 0,
"startDate": "2017-06-19",
"totalUnits": 0,
"transactableUnits": 0,
"transactableValue": 0,
"unclearedUnits": 0,
"unitPrice": 1082.44,
"unitPriceDate": "2018-08-31"
},
{
"availableMarketValue": 29581.149667,
"availableUnits": 2719.8056,
"brokerName": "SCI DIRECT SPECIAL FEES",
"brokerNumber": 102000000,
"clientAccountNumber": 1293874,
"currencyCode": "ZAR",
"currencySymbol": null,
"debitOrderCurrentAmount": 0,
"fund": {
"currencyCode": "ZAR",
"currencySymbol": null,
"cutOffTime": null,
"endDate": null,
"fundName": "DENKER SCI EMERGING MARKETS FEEDER FUND B1",
"fundNumber": 860,
"jseCode": "SFFB1",
"launchDate": null,
"mancoNumber": 0,
"maxDebitOrderAmount": null,
"maxLumpSumAmount": null,
"minDebitOrderAmount": null,
"minLumpSumAmount": null,
"minWithdrawalAmount": null,
"unitPrice": 1087.62
},
"hasRecurringDebitOrder": false,
"initialFee": 0,
"isActive": true,
"marketValue": 29581.14966672,
"pendingUnits": 0,
"pendingValue": 0,
"startDate": "2017-06-18",
"totalUnits": 2719.8056,
"transactableUnits": 2719.8056,
"transactableValue": 29581.14966672,
"unclearedUnits": 0,
"unitPrice": 1087.62,
"unitPriceDate": "2018-08-31"
},
{
"availableMarketValue": 34584.129233,
"availableUnits": 155.1031,
"brokerName": "SCI DIRECT SPECIAL FEES",
"brokerNumber": 102000000,
"clientAccountNumber": 1411734,
"currencyCode": "ZAR",
"currencySymbol": null,
"debitOrderCurrentAmount": 0,
"fund": {
"currencyCode": "ZAR",
"currencySymbol": null,
"cutOffTime": null,
"endDate": null,
"fundName": "SIM GENERAL EQUITY FUND B8",
"fundNumber": 569,
"jseCode": "SGEB8",
"launchDate": null,
"mancoNumber": 0,
"maxDebitOrderAmount": null,
"maxLumpSumAmount": null,
"minDebitOrderAmount": null,
"minLumpSumAmount": null,
"minWithdrawalAmount": null,
"unitPrice": 22297.51
},
"hasRecurringDebitOrder": false,
"initialFee": 0,
"isActive": true,
"marketValue": 34584.12923281,
"pendingUnits": 0,
"pendingValue": 0,
"startDate": "2018-04-26",
"totalUnits": 155.1031,
"transactableUnits": 155.1031,
"transactableValue": 34584.12923281,
"unclearedUnits": 0,
"unitPrice": 22297.51,
"unitPriceDate": "2018-08-31"
}
]
}
]
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment