DEV Community: Tradefeeds

Complete Data in One Mutual Funds API

Tradefeeds — Mon, 14 Aug 2023 05:51:00 +0000

Is someone looking for mutual fund data? 👀 Tradefeeds Mutual Funds API is a great tool to fetch and implement all data you can think of with mutual funds. Its JSON REST structure makes the integration easy and allows a smoother programming experience with tons of documentation available online. The API includes many types of mutual funds that will answer all demands from your clients. These include equity (stock) funds, bond (fixed-income) funds, growth funds, balanced funds and money market funds.

In this post, we wanted to introduce you to our Mutual Funds API, what the data actually looks like and include some useful links to intrigue you, our developer friends 👩🏻‍💻👨🏼‍💻🧑🏽‍💻

Get Both Daily Updated and Historical Mutual Funds Data

Yes, this Mutual Funds API will get you both daily updates while allowing you to set a historical date range and get complete mutual funds data for that. Compared to settling with multiple brokerages or investment funds and aggregating this mutual fund data on your end, an API is a perfect tool for developers when it comes to especially daily updates. We work with the same logic as we gather our data from prestigious fund issuers that we’ve partnered with as well as our data partners and publicly available data when possible. This composition makes the API a perfect one-in-all tool for mutual funds data.

Format: The REST API responds in JSON. Need other formats? Our team of developers might give you what you are looking for. Contact us and let’s discuss your requirements.

Mutual funds are very convenient choices of investment with their ease of liquidation, dynamic and open structure, ease of risk assessment and allowing investors to have a diverse portfolio. As a business in finance, mutual fund data will always be something that your clients demand from you. We’re here to get you covered! Let’s see what the data looks like below 👇🏼

API Endpoints – Fund Info, Holdings and Periodical Returns

We basically have 3 endpoints for this API, each focusing on a different data set for mutual funds. Below, there will be an example response for each endpoint which is perfect to visualize the data before getting started. This example is for USA Mutuals fund.

📌 /mutual_fund_information? : General information for the mutual fund.

https://data.tradefeeds.com/api/v1/mutual_fund_information?key=API_KEY&regCik=1137095
{
    "status": {
        "code": 200,
        "message": "OK",
        "details": ""
    },
    "result": {
        "basics": {
            "regName": "USA Mutuals",
            "regFileNumber": "811-10319",
            "regCik": "0001137095",
            "regLei": "549300IJ0KFT977YGX93"
        },
        "output": [
            {
                "general": {
                    "regName": "USA Mutuals",
                    "regCik": "0001137095",
                    "regLei": "549300IJ0KFT977YGX93",
                    "regCountry": "US",
                    "regState": "US-TX",
                    "regCity": "Dallas",
                    "regZipOrPostalCode": "75201",
                    "regStreet1": "700 N. Pearl Street",
                    "regPhone": "866-264-8783"
                },
                "0": {
                    "attributes": {
                        "seriesName": "USA Mutuals Vitium Global Fund",
                        "seriesId": "S000005505",
                        "seriesLei": "549300GX5CPIZQ5PDX31",
                        "repPdDate": "2020-12-31",
                        "repPdEnd": "2021-03-31",
                        "isFinalFiling": 1
                    },
                    "fund_info": {
                        "totAssets": "111438858.600000000000",
                        "totLiabs": "1741129.050000000000",
                        "netAssets": "109697729.550000000000",
                        "assetsAttrMiscSec": "0.000000000000",
                        "assetsInvested": "0.000000000000",
                        "amtPayOneYrBanksBorr": "591000.000000000000",
                        "amtPayOneYrCtrldComp": "0.000000000000",
                        "amtPayOneYrOthAffil": "0.000000000000",
                        "amtPayOneYrOther": "0.000000000000",
                        "amtPayAftOneYrBanksBorr": "0.000000000000",
                        "amtPayAftOneYrCtrldComp": "0.000000000000",
                        "amtPayAftOneYrOthAffil": "0.000000000000",
                        "amtPayAftOneYrOther": "0.000000000000",
                        "delayDeliv": "0.000000000000",
                        "standByCommit": "0.000000000000",
                        "liquidPref": "0.000000000000",
                        "cshNotRptdInCorD": "2545141.120000000000",
                        "isNonCashCollateral": "N",
                        "currency": "Null"
                    }
                },
                "1": {
                    "attributes": {
                        "seriesName": "USA Mutuals Navigator Fund",
                        "seriesId": "S000058976",
                        "seriesLei": "549300CS0EIS27ZLBG68",
                        "repPdDate": "2020-12-31",
                        "repPdEnd": "2021-03-31",
                        "isFinalFiling": 1
                    },
                    "fund_info": {
                        "totAssets": "44290035.570000000000",
                        "totLiabs": "208427.160000000000",
                        "netAssets": "44081608.410000000000",
                        "assetsAttrMiscSec": "0.000000000000",
                        "assetsInvested": "0.000000000000",
                        "amtPayOneYrBanksBorr": "0.000000000000",
                        "amtPayOneYrCtrldComp": "0.000000000000",
                        "amtPayOneYrOthAffil": "0.000000000000",
                        "amtPayOneYrOther": "0.000000000000",
                        "amtPayAftOneYrBanksBorr": "0.000000000000",
                        "amtPayAftOneYrCtrldComp": "0.000000000000",
                        "amtPayAftOneYrOthAffil": "0.000000000000",
                        "amtPayAftOneYrOther": "0.000000000000",
                        "delayDeliv": "0.000000000000",
                        "standByCommit": "0.000000000000",
                        "liquidPref": "0.000000000000",
                        "cshNotRptdInCorD": "34462732.210000000000",
                        "isNonCashCollateral": "N",
                        "currency": "Null"
                    }
                }
            }
        ]
    }
}

📌 /mutual_fund_periodical_returns? : Periodical returns for a mutual fund. You can optionally set a date range as in the example below.

https://data.tradefeeds.com/api/v1/mutual_fund_periodical_returns?key=API_KEY&seriesId=S000005505&date_from=2010-09-30&date_to=2025-11-30

{
    "status": {
        "code": 200,
        "message": "OK",
        "details": ""
    },
    "result": {
        "basics": {
            "regName": "USA Mutuals",
            "regFileNumber": "811-10319",
            "regCik": "0001137095",
            "regLei": "549300IJ0KFT977YGX93"
        },
        "output": [
            {
                "attributes": {
                    "seriesName": "USA Mutuals Vitium Global Fund",
                    "seriesId": "S000005505",
                    "seriesLei": "549300GX5CPIZQ5PDX31",
                    "repPdDate": "2020-12-31",
                    "repPdEnd": "2021-03-31",
                    "isFinalFiling": 1
                },
                "signature": {
                    "dateSigned": "2021-02-09",
                    "nameOfApplicant": "USA Mutuals",
                    "signature": "/s/ Richard Sapio",
                    "signerName": "Richard Sapio",
                    "title": "President"
                },
                "return_info": {
                    "monthly_total_returns": [
                        {
                            "class_id": "C000014988",
                            "0": {
                                "rtn1": "-6.820000000000",
                                "rtn2": "15.030000000000",
                                "rtn3": "4.540000000000"
                            }
                        },
                        {
                            "class_id": "C000106574",
                            "0": {
                                "rtn1": "-6.780000000000",
                                "rtn2": "15.000000000000",
                                "rtn3": "4.530000000000"
                            }
                        },
                        {
                            "class_id": "C000106575",
                            "0": {
                                "rtn1": "-6.850000000000",
                                "rtn2": "14.920000000000",
                                "rtn3": "4.520000000000"
                            }
                        },
                        {
                            "class_id": "C000129812",
                            "0": {
                                "rtn1": "-6.780000000000",
                                "rtn2": "15.060000000000",
                                "rtn3": "4.560000000000"
                            }
                        }
                    ],
                    "othMon1": {
                        "netRealizedGain": "1047242.290000000000",
                        "netUnrealizedAppr": "-8495540.410000000000"
                    },
                    "othMon2": {
                        "netRealizedGain": "682677.450000000000",
                        "netUnrealizedAppr": "14452752.560000000000"
                    },
                    "othMon3": {
                        "netRealizedGain": "81689.110000000000",
                        "netUnrealizedAppr": "4566807.660000000000"
                    },
                    "mon1Flow": {
                        "redemption": "-2555820.560000000000",
                        "reinvestment": ".000000000000",
                        "sales": "127367.110000000000"
                    },
                    "mon2Flow": {
                        "redemption": "-3177883.990000000000",
                        "reinvestment": ".000000000000",
                        "sales": "769141.370000000000"
                    },
                    "mon3Flow": {
                        "redemption": "-3281011.540000000000",
                        "reinvestment": "4079781.690000000000",
                        "sales": "240630.130000000000"
                    },
                    "monthly_return_categories": {
                        "equityContracts": {
                            "mon1": {
                                "netRealizedGain": "-68969.790000000000",
                                "netUnrealizedAppr": "455219.160000000000"
                            },
                            "mon2": {
                                "netRealizedGain": "-107563.080000000000",
                                "netUnrealizedAppr": "-708108.530000000000"
                            },
                            "mon3": {
                                "netRealizedGain": "162179.700000000000",
                                "netUnrealizedAppr": "2346.670000000000"
                            },
                            "futureCategory": {
                                "instrMon1": {
                                    "netRealizedGain": "N/A",
                                    "netUnrealizedAppr": "N/A"
                                },
                                "instrMon2": {
                                    "netRealizedGain": "102949.590000000000",
                                    "netUnrealizedAppr": "N/A"
                                },
                                "instrMon3": {
                                    "netRealizedGain": "199347.040000000000",
                                    "netUnrealizedAppr": "51156.750000000000"
                                }
                            },
                            "optionCategory": {
                                "instrMon1": {
                                    "netRealizedGain": "-68969.790000000000",
                                    "netUnrealizedAppr": "455219.160000000000"
                                },
                                "instrMon2": {
                                    "netRealizedGain": "-210512.670000000000",
                                    "netUnrealizedAppr": "-708108.530000000000"
                                },
                                "instrMon3": {
                                    "netRealizedGain": "-37167.340000000000",
                                    "netUnrealizedAppr": "-48810.080000000000"
                                }
                            }
                        }
                    }
                }
            },
…..
                }
            }
        ]
    }
}

📌 /mutual_fund_holdings? : Use this endpoint to get mutual fund constituents data and see the composition. You can optionally set up a date range for the report dates.

{
    "status": {
        "code": 200,
        "message": "OK",
        "details": ""
    },
    "result": {
        "basics": {
            "regName": "USA Mutuals",
            "regFileNumber": "811-10319",
            "regCik": "0001137095",
            "regLei": "549300IJ0KFT977YGX93"
        },
        "output": [
            {
                "attributes": {
                    "seriesName": "USA Mutuals Vitium Global Fund",
                    "seriesId": "S000005505",
                    "seriesLei": "549300GX5CPIZQ5PDX31",
                    "repPdDate": "2020-12-31",
                    "repPdEnd": "2021-03-31",
                    "isFinalFiling": 1
                },
                "signature": {
                    "dateSigned": "2021-02-09",
                    "nameOfApplicant": "USA Mutuals",
                    "signature": "/s/ Richard Sapio",
                    "signerName": "Richard Sapio",
                    "title": "President"
                },
                "invstOrSecs": [
                    {
                        "invstOrSec": {
                            "name": "BAE Systems PLC",
                            "lei": "8SVCSVKSGDWMW2QHOH83",
                            "isin": "GB0002634946",
                            "cusip": "G06940103",
                            "balance": "477704.000000000000",
                            "units": "NS",
                            "curCd": "GBP",
                            "valUSD": "3193142.180000000000",
                            "pctVal": "2.9108553049",
                            "payoffProfile": "Long",
                            "assetCat": "EC",
                            "issuerCat": "CORP",
                            "invCountry": "GB",
                            "isRestrictedSec": "N",
                            "fairValLevel": "1",
                            "isCashCollateral": "N",
                            "isNonCashCollateral": "N",
                            "isLoanByFund": "N"
                        }
                    },
                    {
                        "invstOrSec": {
                            "name": "British American Tobacco PLC",
                            "lei": "213800FKA5MF17RJKT63",
                            "isin": "US1104481072",
                            "cusip": "110448107",
                            "balance": "143000.000000000000",
                            "units": "NS",
                            "curCd": "USD",
                            "valUSD": "5361070.000000000000",
                            "pctVal": "4.8871294073",
                            "payoffProfile": "Long",
                            "assetCat": "EC",
                            "issuerCat": "CORP",
                            "invCountry": "GB",
                            "isRestrictedSec": "N",
                            "fairValLevel": "1",
                            "isCashCollateral": "N",
                            "isNonCashCollateral": "N",
                            "isLoanByFund": "N"
                        }
…..
    }
}

Access the Mutual Fund Constituents API

Intrigued?👀 The Mutual Fund Constituents API is an optimal tool which you can use to display general mutual fund info, mutual fund constituents data and help analyze periodical returns. We aggregate an extensive selection of mutual fund information on our end, so you don’t have to. Click below to see our affordable prices and receive your API key in a minute.

Tip: Looking for mutual fund data that we did not mention above? Contact us and we can possibly get the data you are looking for thanks to our extensive financial data network!

Pricing Plans - Tradefeeds API Financial Database

You can choose from four main subscription plans: starter, standard, business and basic. Tradefeeds Financial database API will serve your needs well.

tradefeeds.com

Smart Investment Platforms With ETF Holdings API 💵

Tradefeeds — Wed, 21 Jun 2023 10:39:35 +0000

If you are running an investment platform or looking to build one, an extensive ETF holdings API is probably one of the first things you would need to look out for. As ETFs are very popular investment options, ETF data is definitely something that you should have on your investment platform. This is because investors will naturally want to keep track of the ETFs they have invested in, when to sell them and analyze which ones to invest in next.

For this exact reason, we want to introduce you to Tradefeed's ETF Holdings API which is a one-in-all API when it comes to ETF holdings data!

ETF Holdings Data – ETF Compositions and Flow

Investment platforms can use the Tradefeeds ETF Holdings API to add features where their clients track compositions and the flow of the ETFs they have invested in, or are interested in.
This is possible by using the “/etf_holdings?” endpoint of the API which provides data about the holdings in an ETF, and therefore its current composition. This ETF holdings data is available both historically and in real-time as the ETF eliminates assets and new ones enter into it.

To visualize the ETF composition data better, let’s take a look at the holding data of SPDR S&P 500 ETF TRUST which is a client favorite.

https://data.tradefeeds.com/api/v1/etf_holdings?key=apikey&seriesLei=549300NZAMSJ8FXPQQ63 

{
    "status": {
        "code": 200,
        "message": "OK",
        "details": ""
    },
    "result": {
        "basics": {
            "regName": "SPDR S&P 500 ETF TRUST",
            "regFileNumber": "811-06125",
            "regCik": "0000884394",
            "regLei": "549300NZAMSJ8FXPQQ63"
        },
        "output": [
            {
                "attributes": {
                    "seriesName": "N/A",
                    "seriesId": null,
                    "seriesLei": "549300NZAMSJ8FXPQQ63",
                    "repPdDate": "2023-03-31",
                    "repPdEnd": "2023-09-30",
                    "isFinalFiling": 0
                },
                "signature": {
                    "dateSigned": "2023-04-28",
                    "nameOfApplicant": "SPDR S&P 500 ETF TRUST",
                    "signature": "Arthur Jensen",
                    "signerName": "Arthur Jensen",
                    "title": "Deputy Treasurer"
                },
                "invstOrSecs": [
                    {
                        "invstOrSec": {
                            "name": "Honeywell International Inc",
                            "lei": "ISRPG12PN4EIEOEMW547",
                            "isin": "US4385161066",
                            "cusip": "438516106",
                            "balance": "7289042.00000000",
                            "units": "NS",
                            "curCd": "USD",
                            "valUSD": "1393081707.04000000",
                            "pctVal": "0.371659064779",
                            "payoffProfile": "Long",
                            "assetCat": "EC",
                            "issuerCat": "CORP",
                            "invCountry": "US",
                            "isRestrictedSec": "N",
                            "fairValLevel": "1",
                            "isCashCollateral": "N",
                            "isNonCashCollateral": "N",
                            "isLoanByFund": "N"
                        }
                    },
                    {
                        "invstOrSec": {
                            "name": "Discover Financial Services",
                            "lei": "Z1YLO2USPORE63VVUL20",
                            "isin": "US2547091080",
                            "cusip": "254709108",
                            "balance": "2912782.00000000",
                            "units": "NS",
                            "curCd": "USD",
                            "valUSD": "287899372.88000000",
                            "pctVal": "0.076808424900",
                            "payoffProfile": "Long",
                            "assetCat": "EC",
                            "issuerCat": "CORP",
                            "invCountry": "US",
                            "isRestrictedSec": "N",
                            "fairValLevel": "1",
                            "isCashCollateral": "N",
                            "isNonCashCollateral": "N",
                            "isLoanByFund": "N"
                        }
                    },
                    {
                        "invstOrSec": {
                            "name": "FMC Corp",
                            "lei": "CKDHZ2X64EEBQCSP7013",
                            "isin": "US3024913036",
                            "cusip": "302491303",
                            "balance": "1367253.00000000",
                            "units": "NS",
                            "curCd": "USD",
                            "valUSD": "166982608.89000000",
                            "pctVal": "0.044549145926",
                            "payoffProfile": "Long",
                            "assetCat": "EC",
                            "issuerCat": "CORP",
                            "invCountry": "US",
                            "isRestrictedSec": "N",
                            "fairValLevel": "1",
                            "isCashCollateral": "N",
                            "isNonCashCollateral": "N",
                            "isLoanByFund": "N"
                        }
                    },
                    {
                        "invstOrSec": {
                            "name": "EQT Corp",
                            "lei": "4NT01YGM4X7ZX86ISY52",
                            "isin": "US26884L1098",
                            "cusip": "26884L109",
                            "balance": "3961434.00000000",
                            "units": "NS",
                            "curCd": "USD",
                            "valUSD": "126409358.94000000",
                            "pctVal": "0.033724643634",
                            "payoffProfile": "Long",
                            "assetCat": "EC",
                            "issuerCat": "CORP",
                            "invCountry": "US",
                            "isRestrictedSec": "N",
                            "fairValLevel": "1",
                            "isCashCollateral": "N",
                            "isNonCashCollateral": "N",
                            "isLoanByFund": "N"
                        }
                    },
                    {
                        "invstOrSec": {
                            "name": "Nordson Corp",
                            "lei": "14OS6Q5N55N95WM84M53",
                            "isin": "US6556631025",
                            "cusip": "655663102",
                            "balance": "585560.00000000",
                            "units": "NS",
                            "curCd": "USD",
                            "valUSD": "130146565.60000000",
                            "pctVal": "0.034721689769",
                            "payoffProfile": "Long",
                            "assetCat": "EC",
                            "issuerCat": "CORP",
                            "invCountry": "US",
                            "isRestrictedSec": "N",
                            "fairValLevel": "1",
                            "isCashCollateral": "N",
                            "isNonCashCollateral": "N",
                            "isLoanByFund": "N"
                        }
                    },
                    {
                        "invstOrSec": {
                            "name": "Charles River Laboratories International Inc",
                            "lei": "549300BSQ0R4UZ5KX287",
                            "isin": "US1598641074",
                            "cusip": "159864107",
                            "balance": "555021.00000000",
                            "units": "NS",
                            "curCd": "USD",
                            "valUSD": "112014338.22000000",
                            "pctVal": "0.029884208495",
                            "payoffProfile": "Long",
                            "assetCat": "EC",
                            "issuerCat": "CORP",
                            "invCountry": "US",
                            "isRestrictedSec": "N",
                            "fairValLevel": "1",
                            "isCashCollateral": "N",
                            "isNonCashCollateral": "N",
                            "isLoanByFund": "N"
                        }
                    },
                    {
                        "invstOrSec": {
                            "name": "EPAM Systems Inc",
                            "lei": "549300XCR4R530HJP604",
                            "isin": "US29414B1044",
                            "cusip": "29414B104",
                            "balance": "622685.00000000",
                            "units": "NS",
                            "curCd": "USD",
                            "valUSD": "186182815.00000000",
                            "pctVal": "0.049671552322",
                            "payoffProfile": "Long",
                            "assetCat": "EC",
                            "issuerCat": "CORP",
                            "invCountry": "US",
                            "isRestrictedSec": "N",
                            "fairValLevel": "1",
                            "isCashCollateral": "N",
                            "isNonCashCollateral": "N",
                            "isLoanByFund": "N"
                        }
                    },
                 ...
                    }
                ]

Tip: As you keep track of an ETF’s constituents data regularly, you can display the flow of the ETFs and how assets move in and out of an ETF.

Explaining the ETF Holdings API Values

Below, we will describe the values you see for each asset in the ETF holdings API output. These are all essential values for analyzing an ETF and have a data-driven understanding of whether it is worth investing in.

Field	Description
name	The name of the asset in the ETF.
lei	LEI of the asset.
isin	ISIN of the asset.
cusip	CUSIP number of the asset.
balance	The balance or quantity of the asset in the ETF.
units	The unit of measurement for the balance ("number of shares" in the example).
curCd	The currency code of the asset.
valUSD	The value of the asset in USD.
pctVal	The percentage value of the asset within the ETF's total portfolio value.
payoffProfile	The payoff profile of the asset.
assetCat	Categorization of the asset.
issuerCat	Categorization of the issuer of the asset.
invCountry	The country of the asset.
isRestrictedSec	Indicates whether the asset is a restricted security.
fairValLevel	Represents the level of fair valuation applied to the asset.
isCashCollateral	Indicates whether the asset is used as cash collateral.
isNonCashCollateral	Indicates whether the asset is used as non-cash collateral.
isLoanByFund	Indicates whether the asset is borrowed by the fund.

Good tip: The historical availability of our ETF constituent data also allows seeing the changes in an ETF within the timeline you request. Since ETFs are easily liquidated and allow short-term buying and selling, historical ETF data can work wonders with calculating an ETF’s risk level and performance. We did not pick the title “smart investment platforms” for nothing 😉

Accessing the ETF Constituents API Easily

To sum things up, this ETF Constituents API basically provides general ETF data, ETF constituents data and ETF periodical returns data for publicly traded ETFs. If you have any requirements about ETF data that you’re unsure whether we have or not, contact our team and let’s talk about it!

To easily get an API key for the ETF constituents data and build smart investment platforms, click below!

Pricing Plans - Tradefeeds API Financial Database

You can choose from four main subscription plans: starter, standard, business and basic. Tradefeeds Financial database API will serve your needs well.

tradefeeds.com