Skip to content

Finnworlds-Financial-data-API/Mutual-Fund-Holdings-API

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 

Repository files navigation

Mutual Fund Holdings API - Finnworlds

The Mutual Fund Holdings API provides detailed data about mutual funds, including fund fundamentals, holdings allocations, and periodical returns. We have divided the mutual funds API into 3 endpoints, so you can get data on the aspect you want, avoiding any data clutter:

Mutual Fund Fundamentals – get total assets, liabilities, net assets, and series-specific details.

Holdings Allocation – get individual security holdings, weights, and other investment details.

Periodical Returns – access historical returns, monthly gains/losses, and cash flow events per reporting period.

Common Use Cases

– Display mutual fund profiles including name, ticker, ISIN, and CIK on financial platforms
– Compare fund net asset value (NAV), total assets, and expense ratios across different funds
– Track fund performance metrics such as returns, dividend yield, and growth over time
– Screen funds by type (equity, bond, balanced, index, etc.) for portfolio selection
– Monitor fund holdings to analyze exposure to specific sectors, industries, or companies
– Evaluate fund risk and stability using ratios, turnover, and performance consistency
– Integrate fund data into robo-advisors, portfolio trackers, and investment research tools
– Benchmark mutual fund performance against indices or competing funds

API Features

  • Fund Fundamentals: total assets, liabilities, net assets, series IDs, LEIs, and report periods
  • Holdings Allocation: individual securities, ISIN/CUSIP, value, percent weight, currency, payoff profile, asset and issuer category, invested country
  • Periodical Returns: monthly total returns, realized/unrealized gains, sales, redemptions, reinvestments, categorized by instrument type
  • Additional Details: signature info, reporting dates, fund identifiers, and regulatory LEI numbers

How to Access the Data

  • JSON REST API
  • Excel CSV download
  • PDF reports
  • Email link

Documentation

Full specifications are available on our documentation, including parameter definitions, output objects, and SDK support for Javascript, JQuery, VueJS, Angular, JAVA, PHP, NodeJS, Python, Go, Ruby, C#, R, Rust, Swift, and Scala.

Examples

1. Mutual Fund Fundamental Data

https://api.finnworlds.com/api/v1/mutualfundinfo?key=APIKEY&cik=1137095

{
    "status": {
        "code": 200,
        "message": "OK",
        "details": ""
    },
    "result": {
        "basics": {
            "fund_name": "USA Mutuals",
            "file_number": "811-10319",
            "cik": "0001137095",
            "reg_lei": "549300IJ0KFT977YGX93"
        },
        "output": [
            {
                "general": {
                    "fund_name": "USA Mutuals",
                    "cik": "0001137095",
                    "reg_lei": "549300IJ0KFT977YGX93",
                    "country": "US",
                    "state": "US-TX",
                    "city": "Dallas",
                    "zip": "75201",
                    "street": "700 N. Pearl Street",
                    "phone": "866-264-8783"
                },
                "attributes": {
                    "series_name": "USA Mutuals Navigator Fund",
                    "series_id": "S000058976",
                    "series_lei": "549300CS0EIS27ZLBG68",
                    "ticker": "",
                    "isin": "",
                    "date_report_period": "2020-03-31",
                    "end_report_period": "2020-03-31",
                    "final_filing": 0
                },
                "fund_info": {
                    "total_assets": "118772571.800000000000",
                    "total_liabilities": "1477059.060000000000",
                    "net_assets": "117295512.740000000000",
                    "assets_attr_misc_sec": "0.000000000000",
                    "invested_assets": "0.000000000000",
                    "one_yr_banks_borr": "0.000000000000",
                    "one_yr_ctrld_comp": "0.000000000000",
                    "one_yr_oth_affil": "0.000000000000",
                    "one_yr_other": "0.000000000000",
                    "aft_one_yr_banks_borr": "0.000000000000",
                    "aft_one_yr_ctrld_comp": "0.000000000000",
                    "aft_one_yr_oth_affil": "0.000000000000",
                    "aft_one_yr_other": "0.000000000000",
                    "delivery_delay": "0.000000000000",
                    "standby_commit": "0.000000000000",
                    "liquid_pref": "0.000000000000",
                    "cash_not_reported_in_cor_d": "13439332.660000000000",
                    "non_cash_collateral": "N",
                    "currency": "USD"
                }
            }
        ]
    }
}

2. Mutual Fund Holdings Data

https://api.finnworlds.com/api/v1/mutualfundholdings?key=APIKEY&ticker=QQQ

{
    "status": {
        "code": 200,
        "message": "OK",
        "details": ""
    },
    "result": {
        "basics": {
            "fund_name": "Invesco QQQ Trust, Series 1",
            "file_number": "811-08947",
            "cik": "0001067839",
            "reg_lei": "549300VY6FEJBCIMET58"
        },
        "output": [
            {
                "attributes": {
                    "series_name": "Invesco QQQ Trust, Series 1",
                    "series_id": null,
                    "series_lei": "549300VY6FEJBCIMET58",
                    "ticker": "QQQ",
                    "isin": "US46090E1038",
                    "date_report_period": "2025-03-31",
                    "end_report_period": "2025-09-30",
                    "final_filing": 0
                },
                "signature": {
                    "date_signed": "2025-04-30",
                    "name_of_applicant": "Invesco QQQ Trust, Series 1",
                    "signature": "Kelli Gallegos",
                    "signer_name": "Kelli Gallegos",
                    "title": "Principal Financial and Accounting Officer"
                },
                "holdings": [
                    {
                        "investment_security": {
                            "name": "AstraZeneca PLC",
                            "lei": "PY6ZZQWO2IZFZC3IOL08",
                            "isin": "US0463531089",
                            "title": "AstraZeneca PLC, ADR",
                            "cusip": "046353108",
                            "balance": "11985397.00000000",
                            "units": "NS",
                            "currency": "USD",
                            "value_usd": "880926679.50000000",
                            "percent_value": "0.296389383931",
                            "payoff_profile": "Long",
                            "asset_category": "EC",
                            "issuer_category": "CORP",
                            "invested_country": "GB",
                            "restricted_sec": "N",
                            "fair_value_level": "1",
                            "cash_collateral": "N",
                            "non_cash_collateral": "N",
                            "loan_by_fund": "N"
                        }
                    },
                    {
                        "investment_security": {
                            "name": "Take-Two Interactive Software, Inc.",
                            "lei": "BOMSTHHJK882EWYX3334",
                            "isin": "US8740541094",
                            "title": "Take-Two Interactive Software, Inc.",
                            "cusip": "874054109",
                            "balance": "3634960.00000000",
                            "units": "NS",
                            "currency": "USD",
                            "value_usd": "753345460.00000000",
                            "percent_value": "0.253464450529",
                            "payoff_profile": "Long",
                            "asset_category": "EC",
                            "issuer_category": "CORP",
                            "invested_country": "US",
                            "restricted_sec": "N",
                            "fair_value_level": "1",
                            "cash_collateral": "N",
                            "non_cash_collateral": "N",
                            "loan_by_fund": "N"
                        }
                    }
                ]
            }
        ]
    }
}

3. Mutual Funds Periodical Returns Data

https://api.finnworlds.com/api/v1/mutualfundreturns?key=APIKEY&ticker=QQQ

{
{
    "status": {
        "code": 200,
        "message": "OK",
        "details": ""
    },
    "result": {
        "basics": {
            "fund_name": "Invesco QQQ Trust, Series 1",
            "file_number": "811-08947",
            "cik": "0001067839",
            "reg_lei": "549300VY6FEJBCIMET58"
        },
        "output": [
            {
                "attributes": {
                    "series_name": "Invesco QQQ Trust, Series 1",
                    "series_id": null,
                    "series_lei": "549300VY6FEJBCIMET58",
                    "ticker": "QQQ",
                    "isin": "US46090E1038",
                    "date_report_period": "2025-03-31",
                    "end_report_period": "2025-09-30",
                    "final_filing": 0
                },
                "signature": {
                    "date_signed": "2025-04-30",
                    "name_of_applicant": "Invesco QQQ Trust, Series 1",
                    "signature": "Kelli Gallegos",
                    "signer_name": "Kelli Gallegos",
                    "title": "Principal Financial and Accounting Officer"
                },
                "return_info": {
                    "monthly_total_returns": [
                        {
                            "class_id": "None",
                            "0": {
                                "rtn1": "2.25912100",
                                "rtn2": "-2.69032600",
                                "rtn3": "-7.61685000"
                            }
                        }
                    ],
                    "other_monthly1": {
                        "net_realized_gain": "6411188498.17000000",
                        "net_unrealized_appreciation": "501141342.46000000"
                    },
                    "other_monthly2": {
                        "net_realized_gain": "4989811744.39000000",
                        "net_unrealized_appreciation": "-14285525152.26000000"
                    },
                    "other_monthly3": {
                        "net_realized_gain": "3296653042.11000000",
                        "net_unrealized_appreciation": "-27959372619.22000000"
                    },
                    "month_1_flow": {
                        "redemption": "34508765578.04000000",
                        "reinvestment": "0.00000000",
                        "sales": "36831885636.09000000"
                    },
                    "month_2_flow": {
                        "redemption": "28159516772.79000000",
                        "reinvestment": "0.00000000",
                        "sales": "32727712814.21000000"
                    },
                    "month_3_flow": {
                        "redemption": "31630541614.26000000",
                        "reinvestment": "0.00000000",
                        "sales": "29982557193.67000000"
                    },
                    "monthly_return_categories": {
                        "commodity": {
                            "month1": {
                                "net_realized_gain": "0.00000000",
                                "net_unrealized_appreciation": "0.00000000"
                            },
                            "month2": {
                                "net_realized_gain": "0.00000000",
                                "net_unrealized_appreciation": "0.00000000"
                            },
                            "month3": {
                                "net_realized_gain": "0.00000000",
                                "net_unrealized_appreciation": "0.00000000"
                            },
                            "forward_category": {
                                "instrmon1": {
                                    "net_realized_gain": "0.00000000",
                                    "net_unrealized_appreciation": "0.00000000"
                                },
                                "instrmon2": {
                                    "net_realized_gain": "0.00000000",
                                    "net_unrealized_appreciation": "0.00000000"
                                },
                                "instrmon3": {
                                    "net_realized_gain": "0.00000000",
                                    "net_unrealized_appreciation": "0.00000000"
                                }
                            },
                            "future_category": {
                                "instrmon1": {
                                    "net_realized_gain": "0.00000000",
                                    "net_unrealized_appreciation": "0.00000000"
                                },
                                "instrmon2": {
                                    "net_realized_gain": "0.00000000",
                                    "net_unrealized_appreciation": "0.00000000"
                                },
                                "instrmon3": {
                                    "net_realized_gain": "0.00000000",
                                    "net_unrealized_appreciation": "0.00000000"
                                }
                            },
                            "option_category": {
                                "instrmon1": {
                                    "net_realized_gain": "0.00000000",
                                    "net_unrealized_appreciation": "0.00000000"
                                },
                                "instrmon2": {
                                    "net_realized_gain": "0.00000000",
                                    "net_unrealized_appreciation": "0.00000000"
                                },
                                "instrmon3": {
                                    "net_realized_gain": "0.00000000",
                                    "net_unrealized_appreciation": "0.00000000"
                                }
                            }
                        }
                    }
                }
            }
        ]
    }
}

Customer Support

Need help, have questions? Get in touch with Support.

Legal

Use of the Finnworlds website, services like API and database are subject to the Finnworlds Terms & Conditions.