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

Revisions

  1. tsotetsi created this gist Aug 28, 2020.
    667 changes: 667 additions & 0 deletions data
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,667 @@
    {
    "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"
    }
    ]
    }
    ]
    }
    }