A comprehensive repository for managing and analyzing ETF (Exchange-Traded Fund) and savings account data from the Johannesburg Stock Exchange (JSE), structured in machine-readable formats.

This repository provides structured data and documentation for South African ETFs, AMETFs (Actively Managed ETFs), AMCs (Actively Managed Certificates), and savings accounts. The data is formatted in multiple machine-readable formats (JSON, YAML, NUON) to facilitate integration with financial analysis tools, portfolio tracking applications, and automated investment platforms.

This repository is designed to power a wide range of applications. Key features and use cases are outlined below, with more detail available in docs/SUGGESTED_FEATURES.md.

• Portfolio & Analytics:

  • Personal Portfolio Tracker: Visualize holdings, track performance, and monitor dividend schedules.
  • Risk Assessment Tool: Analyze portfolio risk, compare domestic vs. foreign exposure, and evaluate sector concentration.
  • Fee Comparison App: Compare management fees and calculate their impact over time.

• Data & APIs:

  • Open REST API Service: Build APIs to query ETF data by type, category, or ticker.
  • ETFs & Savings Screener: Filter funds based on multiple criteria, including dividend frequency.
  • Multi-Format Converter: Convert data between JSON, YAML, NUON, and other formats like CSV.

• Command-Line Tools:

  • Nushell ETF Explorer: Use the NUON format for powerful command-line analysis with Nushell.
  • jq Query Builder: Leverage pre-built jq queries for complex JSON data manipulation.

• Integration:

  • Budgeting App Integration: Sync ETF data with tools like YNAB or Mint.
  • Tax Reporting Helper: Export data to assist with SARS e-filing.
  • Spreadsheet Add-ons: Create plugins for Google Sheets or Excel to import and auto-update fund data.

• Educational & Visualization:

  • ETF/SA Explorer: Build interactive tools to explain key investment concepts.
  • Geographic Exposure Mapper: Visualize global ETF exposure with interactive maps.
  • Sector Allocation Dashboard: Create charts to visualize sector allocations across a portfolio.

etfsa.json/
├── README.md           # This file
├── data/              # Structured data files
│   ├── etfsa.json     # Main dataset in JSON format
│   ├── etfsa.yaml     # Main dataset in YAML format
│   └── etfsa.nuon     # Main dataset in Nushell Object Notation
└── docs/              # Documentation and analysis
    ├── IDEAS.md       # Application ideas and use cases
    ├── ANALYSIS.md    # Comprehensive market analysis of JSE ETFs
    └── MEMORANDUM.md  # Analysis of actively managed products (AMETFs & AMCs)

The dataset includes the following information for each fund:

• Fund Name: Official name of the ETF/fund
• Ticker: JSE trading symbol
• Type: Classification (ETF, AMETF, AMC, ETN, etc.)
• Category: Investment category and strategy
• Description: Detailed investment focus and methodology
• Dividends Paid: Distribution frequency (Q=Quarterly, Bi-A=Bi-Annually, M=Monthly, etc.)

• Broad Equity Market Access (Top 40, All Share, Next 40)
• JSE Sector-Specific Exposure (Financials, Industrials, Resources, MidCap)
• Fixed Income and Interest Rate
• Property and REITs
• Factor-Based and Smart Beta
• Thematic and ESG

• Global Equity Indices
• Regional Exposure (US, Europe, Asia, Emerging Markets)
• Sector-Specific (Technology, Healthcare, etc.)
• Fixed Income
• Commodities and Currency

• Actively Managed ETFs (AMETFs)
• Actively Managed Certificates (AMCs)
• Multi-asset and balanced funds

A comprehensive market analysis providing:

• Comparative overview of domestic vs. foreign ETFs
• Detailed categorization of investment options
• Analysis of weighting methodologies (market-cap vs. SWIX)
• Sector-specific and thematic investment strategies
• Current market data as of October 2025

An investment committee memorandum analyzing:

• Actively Managed ETFs (AMETFs) landscape
• Actively Managed Certificates (AMCs)
• Strategic allocation opportunities
• Geographic and asset class diversification strategies

A categorized list of potential applications and use cases, including:

• Portfolio tracking and analytics tools
• Risk assessment applications
• Fee comparison utilities
• API services and data integration
• Educational and visualization tools

1. Clone the repository:

   git clone https://github.com/soli-rsa/etfsa.json.git
   cd etfsa.json

2. Explore the data:

   • View data files in the data/ directory
   • Choose your preferred format: JSON, YAML, or NUON

3. Read the documentation:

   • Start with ANALYSIS.md for market insights
   • Review IDEAS.md for application inspiration
   • Check MEMORANDUM.md for active management strategies

This dataset can be used for:

• Financial Analysis: Analyze trends, correlations, and performance metrics
• Portfolio Construction: Build diversified investment portfolios
• API Development: Create REST APIs for querying ETF/SA data
• Investment Tools: Develop screeners, comparators, and trackers
• Educational Platforms: Build learning tools for investors
• Tax Reporting: Generate reports for tax filing purposes
• Risk Management: Assess portfolio risk and exposure

Standard JSON format for maximum compatibility with modern applications and APIs.

Human-readable YAML format, ideal for configuration management and data visualization tools.

Optimized for use with Nushell, a modern shell with built-in data manipulation capabilities.

Contributions are welcome! Here's how you can help:

• Data Updates: Submit corrections or additions to fund data
• Documentation: Improve analysis or add new insights
• App Ideas: Suggest new use cases in IDEAS.md
• Bug Reports: Report data inconsistencies or errors

Please open an issue or submit a pull request with your contributions.

The data in this repository is current as of October 2025. For the most up-to-date information, please verify directly with the JSE or fund providers.

This repository is for informational and educational purposes only. It does not constitute financial advice. Always consult with a qualified financial advisor before making investment decisions. The maintainers of this repository are not responsible for any investment decisions made based on this data.

[Specify your license here, e.g., MIT, Apache 2.0, etc.]

• Johannesburg Stock Exchange (JSE)
• Application Ideas
• Market Analysis
• Active Management Analysis

Questions or suggestions? Open an issue or contribute to the discussion!