### Cotizaciones V2 API Example - Volume Source: https://databursatil.com/docs.html Example for the Cotizaciones V2 API to get volume ('O') for multiple emisoras and bolsas. Requires token, concept, emisora_serie, and bolsa. ```HTTP https://api.databursatil.com/v2/cotizaciones?token=TU_TOKEN&concepto=O&emisora_serie=AC*,ALFAA,ALSEA*,AMXB,ASURB,BBAJIOO,BIMBOA,BOLSAA,CEMEXCPO,CHDRAUIB,CUERVO*,FEMSAUBD,GAPB,GCC*,GENTERA*,GFINBURO,GFNORTEO,GMEXICOB,GRUMAB,KIMBERA,KOFUBL,LABB,LACOMERUBC,LIVEPOLC-1,MEGACPO,OMAB,ORBIA*,PENOLES*,PINFRA*,TLEVISACPO,VESTA*,WALMEX*&bolsa=BMV,BIVA ``` -------------------------------- ### Cotizaciones V2 API Example - Previous Price Source: https://databursatil.com/docs.html Example for the Cotizaciones V2 API to get the previous price ('P') for a specific emisora and multiple bolsas. Requires token, concept, emisora_serie, and bolsa. ```HTTP https://api.databursatil.com/v2/cotizaciones?token=TU_TOKEN&concepto=P&emisora_serie=GFNORTEO&bolsa=BMV,BIVA ``` -------------------------------- ### Cotizaciones V2 API Example - Volume (BIVA) Source: https://databursatil.com/docs.html Example for the Cotizaciones V2 API to get volume ('O') for a specific emisora on the BIVA bolsa. Requires token, concept, emisora_serie, and bolsa. ```HTTP https://api.databursatil.com/v2/cotizaciones?token=TU_TOKEN&concepto=O&emisora_serie=GFNORTEO&bolsa=BIVA ``` -------------------------------- ### Emisoras API Examples Source: https://databursatil.com/docs.html Examples of how to query the Emisoras API with different parameters for market, letter, and token. ```HTTP https://api.databursatil.com/v2/emisoras?token=TU_TOKEN&mercado=local&letra=AC https://api.databursatil.com/v2/emisoras?token=TU_TOKEN&mercado=global https://api.databursatil.com/v2/emisoras?token=TU_TOKEN&letra=NFLX https://api.databursatil.com/v2/emisoras?token=TU_TOKEN&mercado=local https://api.databursatil.com/v2/emisoras?token=TU_TOKEN ``` -------------------------------- ### API Request with Token Example Source: https://databursatil.com/docs.html This example demonstrates how to construct a URL for the 'Emisoras V2' endpoint, including the required 'token' parameter and optional 'letra' and 'mercado' filters. ```URL https://api.databursatil.com/v2/emisoras?token=TU_TOKEN&letra=H&mercado=local ``` -------------------------------- ### Intradia V2 API Example Source: https://databursatil.com/docs.html Example request for the Intradia V2 API to get historical quotes during the trading day. Requires token, emisora_serie, bolsa, interval, and date range. ```HTTP https://api.databursatil.com/v2/intradia?token=TU_TOKEN&emisora_serie=ALSEA*,GFNORTEO&bolsa=BMV&intervalo=1h&inicio=2025-05-09&final=2025-05-09 ``` -------------------------------- ### Intradia V2 API Multiple Examples Source: https://databursatil.com/docs.html Various examples for the Intradia V2 API demonstrating different combinations of emisora_serie, bolsa, and interval for fetching intraday quotes. ```HTTP https://api.databursatil.com/v2/intradia?token=TU_TOKEN&emisora_serie=WALMEX*,AMXB,GMEXICOB,GFNORTEO,FEMSAUBD,AC*,GFINBURO,GCARSOA1,GAPB,ASURB,BIMBOA&bolsa=BMV&intervalo=1h&inicio=2025-05-09&final=2025-05-09 https://api.databursatil.com/v2/intradia?token=TU_TOKEN&emisora_serie=ALSEA*,ALFAA&bolsa=BMV&intervalo=1m&inicio=2025-05-28&final=2025-05-28 https://api.databursatil.com/v2/intradia?token=TU_TOKEN&emisora_serie=ALSEA*,CEMEXCPO&bolsa=BIVA&intervalo=5m&inicio=2025-05-09&final=2025-05-09 https://api.databursatil.com/v2/intradia?token=TU_TOKEN&emisora_serie=ALSEA*,CEMEXCPO&bolsa=BIVA&intervalo=1m&inicio=2025-05-09&final=2025-05-09 https://api.databursatil.com/v2/intradia?token=TU_TOKEN&emisora_serie=ALSEA*&bolsa=BMV&intervalo=1h&inicio=2024-12-19&final=2024-12-20 ``` -------------------------------- ### Get Historical Prices (Different Issuers) Source: https://databursatil.com/docs.html Examples of retrieving historical prices for different issuers. Note the use of '*' for series, which may indicate a wildcard or a specific series format. ```HTTP https://api.databursatil.com/v2/historicos?token=TU_TOKEN&inicio=2025-01-01&final=2025-06-07&emisora_serie=GCARSOA1 ``` ```HTTP https://api.databursatil.com/v2/historicos?token=TU_TOKEN&inicio=2025-01-01&final=2025-06-07&emisora_serie=AAPL* ``` ```HTTP https://api.databursatil.com/v2/historicos?token=TU_TOKEN&inicio=2025-01-01&final=2025-06-07&emisora_serie=NFLX* ``` -------------------------------- ### JSON Example Source: https://databursatil.com/docs.html This is an example of data in JSON format, which is used for data exchange and is the format for all content downloaded from the API. ```json { "clave": "BMV", "nombre": "Bolsa Mexicana de Valores", "mercado": "BMV", "sector": "Mercado de Valores", "subsector": "Bolsas de Valores", "tipo": "Bolsa", "estatus": "Activo" } ``` -------------------------------- ### Cotizaciones V2 API Example (Incorrect Endpoint) Source: https://databursatil.com/docs.html This example appears to be for the Intradia V2 API, not Cotizaciones V2, based on the URL structure. It shows a request for specific concepts and multiple bolsas. ```HTTP https://api.databursatil.com/v2/intradia?token=TU_TOKEN&emisora_serie=AC*,ALFAA&concepto=u,p,a,x,n,c,m,v,o,i&bolsa=bmv,biva ``` -------------------------------- ### Cotizaciones V2 API Example - Multiple Concepts Source: https://databursatil.com/docs.html Example for the Cotizaciones V2 API to retrieve multiple price concepts (U, P, A, X, N, C, M, V, O, I) for specific emisoras on the BMV bolsa. Requires token, concept, emisora_serie, and bolsa. ```HTTP https://api.databursatil.com/v2/cotizaciones?token=TU_TOKEN&concepto=U,P,A,X,N,C,M,V,O,I&emisora_serie=AC*,GAPB&bolsa=BMV ``` -------------------------------- ### Get All Commodities Source: https://databursatil.com/docs.html Fetches all available commodity data. Requires an authentication token. ```HTTP https://api.databursatil.com/v2/commodities?token=TU_TOKEN ``` -------------------------------- ### Get News Headlines Source: https://databursatil.com/docs.html Fetches main business and economy headlines. Requires an authentication token. ```HTTP https://api.databursatil.com/v2/noticias?token=TU_TOKEN ``` -------------------------------- ### Get Cables (News Wires) Source: https://databursatil.com/docs.html Fetches news wires from Mexican issuers and general economy/business news. Requires an authentication token. Can filter by categories. ```HTTP https://api.databursatil.com/v2/cables?token=TU_TOKEN ``` ```HTTP https://api.databursatil.com/v2/cables?token=TU_TOKEN&categorias=top ``` ```HTTP https://api.databursatil.com/v2/cables?token=TU_TOKEN&categorias=generales,valuaciones ``` ```HTTP https://api.databursatil.com/v2/cables?token=TU_TOKEN&categorias=boletines,top,valuaciones,flash,generales ``` -------------------------------- ### API Base URL and Versioning Source: https://databursatil.com/docs.html All API requests start with this base URL, followed by the requested version. HTTP requests are redirected to HTTPS. ```bash https://api.databursatil.com/v2/ ``` -------------------------------- ### GET /v2/top Source: https://databursatil.com/docs.html Retrieves market rankings for specified variables, bolsa, market, and date range. Allows filtering by up, down, amount, volume, and operations. ```APIDOC ## GET /v2/top ### Description Retrieves market rankings for specified variables, bolsa, market, and date range. Allows filtering by up, down, amount, volume, and operations. ### Method GET ### Endpoint https://api.databursatil.com/v2/top ### Parameters #### Query Parameters - **token** (string) - Required - Authentication method - **variables** (string) - Required - Specifies the type of ranking required. Available options: "suben", "bajan", "importe", "volumen" and/or "operaciones". Multiple can be selected separating by comma. - **bolsa** (string) - Required - Specifies the origin of the quotes. Only two options available: "BMV" or "BIVA". Only one can be entered. - **cantidad** (integer) - Required - Specifies the number of issuers requested per declared filter. Minimum of 1 and maximum of 50. - **mercado** (string) - Required - Specifies the market of the quotes. Only two options available: "local" or "global". Only one can be entered. - **inicio** (string) - Required - Start date of the quotes in YYYY-MM-DD format - **final** (string) - Required - End date of the quotes in YYYY-MM-DD format ### Response #### Success Response (200) - **suben** (object) - Contains issuers filtered by percentage increase - **bajan** (object) - Contains issuers filtered by percentage decrease - **volumen** (object) - Contains issuers filtered by highest traded volume - **importe** (object) - Contains issuers filtered by highest traded amount - **operaciones** (object) - Contains issuers filtered by highest number of operations - **e** (decimal) - Issuer with series in the top - **u** (decimal) - Last trade of the issuer - **c** (decimal) - Negotiated shares for the issuer - **f** (string) - Date in YYYY-MM-DD format corresponding to the top ### Request Example ```json { "example": "https://api.databursatil.com/v2/top?token=TU_TOKEN&variables=suben,bajan,importe,volumen,operaciones&bolsa=BMV&cantidad=2&mercado=local&inicio=2025-06-06&final=2025-06-06" } ``` ### Response Example ```json { "example": "[Response body will contain data based on the query]" } ``` ``` -------------------------------- ### GET /v2/financieros Source: https://databursatil.com/docs.html Retrieves financial statements for the requested period and issuer. ```APIDOC ## GET /v2/financieros ### Description Retrieves financial statements for the requested period and issuer. ### Method GET ### Endpoint https://api.databursatil.com/v2/financieros ### Parameters #### Query Parameters - **token** (string) - Required - Authentication method - **emisora** (string) - Required - Specifies the issuer (without series) for which financial statements are requested - **periodo** (string) - Required - Specifies the requested period for the financial statements. For example: '1T_2025' (first quarter of 2025) - **financieros** (string) - Required - Specifies the list of requested financial statements. Available options: "posicion", "flujos", "resultado_trimestre" and/or "resultado_acumulado". Multiple can be selected separated by comma. - posicion=Balance Sheet - flujos=Cash Flow Statement - resultado_trimestre=Quarterly Income Statement - resultado_acumulado=Accumulated Quarterly Income Statement ### Request Example ```json { "example": "[Example request URL would be constructed based on parameters]" } ``` ### Response #### Success Response (200) - **[Financial Statement Data]** - The response will contain the requested financial statement data based on the 'financieros' parameter. ### Response Example ```json { "example": "[Response body will contain the requested financial statement data]" } ``` ``` -------------------------------- ### Get Credits Source: https://databursatil.com/docs.html Retrieves the available credits associated with the provided API token. This endpoint is useful for checking your current credit balance. ```APIDOC ## GET /v2/creditos ### Description Retrieves the available credits associated with the provided API token. ### Method GET ### Endpoint https://api.databursatil.com/v2/creditos ### Parameters #### Query Parameters - **token** (string) - Required - Authentication method. ### Response #### Success Response (200) - **disponibles** (string) - Available credits at the time of the query. ### Request Example ```json { "example": "https://api.databursatil.com/v2/creditos?token=TU_TOKEN" } ``` ### Response Example ```json { "example": "{\"disponibles\": \"1000\"}" } ``` ``` -------------------------------- ### Get Available Credits Source: https://databursatil.com/docs.html Retrieve the number of available credits associated with your API token. Replace 'TU_TOKEN' with your actual API token. ```HTTP https://api.databursatil.com/v2/creditos?token=TU_TOKEN ``` -------------------------------- ### GET /v2/historicos Source: https://databursatil.com/docs.html Obtains historical prices at closing for the requested issuer and series. ```APIDOC ## GET /v2/historicos ### Description Obtains historical prices at closing for the requested issuer and series. ### Method GET ### Endpoint https://api.databursatil.com/v2/historicos ### Parameters #### Query Parameters - **token** (string) - Required - Authentication method - **emisora_serie** (string) - Required - Specifies the issuer with series for which quotes are requested. Only allows 1 issuer with series. - **inicio** (string) - Required - Start date of the requested price range in YYYY-MM-DD format - **final** (string) - Required - End date of the requested price range in YYYY-MM-DD format ### Response #### Success Response (200) - **[fecha]** (date) - Date in YYYY-MM-DD format for the reference day - **precio** (decimal) - Closing price of the issuer on the reference day - **importe** (decimal) - Amount traded for the issuer on the reference day ### Request Example ```json { "example": "https://api.databursatil.com/v2/historicos?token=TU_TOKEN&inicio=2025-06-01&final=2025-06-07&emisora_serie=ALSEA*" } ``` ### Response Example ```json { "example": "[Response body will contain historical price data]" } ``` ``` -------------------------------- ### Get Market Top Data (Bajan Only) Source: https://databursatil.com/docs.html Retrieve only 'bajan' (losers) data for a specific exchange and market. This snippet shows how to request a single type of market performance. ```HTTP https://api.databursatil.com/v2/top?token=TU_TOKEN&variables=bajan&bolsa=BIVA&cantidad=5&mercado=local&inicio=2025-06-06&final=2025-06-06 ``` -------------------------------- ### Commodities API Source: https://databursatil.com/docs.html Get prices for major commodity crosses. You can filter by specific commodity tickers. ```APIDOC ## GET /v2/commodities ### Description Retrieves prices for major commodity crosses. Allows filtering by specific commodity tickers. ### Method GET ### Endpoint /v2/commodities ### Parameters #### Query Parameters - **token** (string) - Required - Authentication method. - **ticker** (string) - Optional - Filter by selected commodity. Multiple tickers can be entered separated by commas. ### Response #### Success Response (200) - **[commodity]** (string) - Commodity name or ticker. - **u** (decimal) - Last price. - **c** (decimal) - Percentage change. - **m** (decimal) - Monetary change. - **f** (Date) - Update date in YYYY-MM-DD format. ### Request Example ```json { "example": "https://api.databursatil.com/v2/commodities?token=TU_TOKEN" } ``` ### Response Example ```json { "example": "[Response body containing commodity data]" } ``` ``` -------------------------------- ### Automate Excel Data Refresh with VBA Source: https://databursatil.com/docs.html This VBA script automates refreshing all data connections in an Excel workbook, saving the workbook, and scheduling itself to run again after a specified interval (5 minutes in this example). ```VBA Sub SaveWb() ThisWorkbook.RefreshAll ThisWorkbook.Save Application.OnTime Now + TimeValue("00:05:00"), "SaveWb" End Sub ``` -------------------------------- ### Get Historical Prices Source: https://databursatil.com/docs.html Retrieve historical closing prices for a specific issuer and series. Requires a token, issuer/series identifier, and a date range. ```HTTP https://api.databursatil.com/v2/historicos?token=TU_TOKEN&inicio=2025-06-01&final=2025-06-07&emisora_serie=ALSEA* ``` -------------------------------- ### Get Specific Commodity Data Source: https://databursatil.com/docs.html Fetches data for a specific commodity by its ticker. Multiple tickers can be requested, separated by commas. Requires an authentication token. ```HTTP https://api.databursatil.com/v2/commodities?token=TU_TOKEN&ticker=paladio ``` ```HTTP https://api.databursatil.com/v2/commodities?token=TU_TOKEN&ticker=uranio,oro ``` -------------------------------- ### Get Market Top Data (Suben Only) Source: https://databursatil.com/docs.html Retrieve only 'suben' (gainers) data for a specific exchange and market. This snippet demonstrates a focused request for a particular variable. ```HTTP https://api.databursatil.com/v2/top?token=TU_TOKEN&variables=suben&bolsa=BMV&cantidad=20&mercado=local&inicio=2025-06-06&final=2025-06-06 ``` -------------------------------- ### Currencies API Source: https://databursatil.com/docs.html Get prices for major currency crosses. You can filter by specific currency pair tickers. ```APIDOC ## GET /v2/divisas ### Description Retrieves prices for major currency crosses. Allows filtering by specific currency pair tickers. ### Method GET ### Endpoint /v2/divisas ### Parameters #### Query Parameters - **token** (string) - Required - Authentication method. - **ticker** (string) - Optional - Filter by selected currency. Multiple tickers can be entered separated by commas. ### Response #### Success Response (200) - **[cruce de divisa]** (string) - Currency cross. - **u** (decimal) - Exchange rate. - **c** (decimal) - Percentage change. - **m** (decimal) - Monetary change. - **f** (Date) - Update date in YYYY-MM-DD format. ### Request Example ```json { "example": "https://api.databursatil.com/v2/divisas?token=TU_TOKEN" } ``` ### Response Example ```json { "example": "[Response body containing currency data]" } ``` ``` -------------------------------- ### Indices API Source: https://databursatil.com/docs.html Get prices for major stock market indices. You can filter the results by specific index tickers. ```APIDOC ## GET /v2/indices ### Description Retrieves prices for major stock market indices. Allows filtering by specific index tickers. ### Method GET ### Endpoint /v2/indices ### Parameters #### Query Parameters - **token** (string) - Required - Authentication method. - **ticker** (string) - Optional - Filter by selected index. Multiple tickers can be entered separated by commas. ### Response #### Success Response (200) - **[indice]** (string) - Short name of the index (ticker). - **nombre** (string) - Long name of the index. - **u** (decimal) - Last price of the index. - **a** (decimal) - Opening price of the index. - **x** (decimal) - Maximum price in the index session. - **n** (decimal) - Minimum price in the index session. - **c** (decimal) - Percentage change based on the previous closing price. - **m** (decimal) - Point change based on the previous closing price. - **v** (decimal) - Volume in the index session. - **ytdp** (decimal) - Percentage change based on the previous year's closing price. - **f** (Date) - Date and time of the data in the format: YYYY-MM-DD hh:mm:ss. ### Request Example ```json { "example": "https://api.databursatil.com/v2/indices?token=TU_TOKEN" } ``` ### Response Example ```json { "example": "[Response body containing index data]" } ``` ``` -------------------------------- ### Get Market Top Data Source: https://databursatil.com/docs.html Retrieve top market data based on various criteria like percentage change, volume, and operations. Ensure to provide a valid token and specify the desired variables, exchange, quantity, market, and date range. ```HTTP https://api.databursatil.com/v2/top?token=TU_TOKEN&variables=suben,bajan,importe,volumen,operaciones&bolsa=BMV&cantidad=2&mercado=local&inicio=2025-06-06&final=2025-06-06 ``` -------------------------------- ### Get Hechos (Transaction Facts) Source: https://databursatil.com/docs.html Filters transaction facts for a specific issuer and series. Requires an authentication token, issuer/series, date, and time range. ```HTTP https://api.databursatil.com/v2/hechos?token=TU_TOKEN&emisora_serie=SOME_ISSUER&fecha=2025-06-02&horai=09:00&horaf=17:00 ``` -------------------------------- ### Download Market Data (Guber Valuations) Source: https://databursatil.com/docs.html Downloads government money market valuations. Requires an authentication token, file type ('guber'), and a specific date. ```HTTP https://api.databursatil.com/v2/descargas?token=TU_TOKEN&archivo=guber&fecha=2025-06-02 ``` -------------------------------- ### Cotizaciones V2 Source: https://databursatil.com/docs.html Fetches the most recent prices for requested issuers and series. Requires authentication token, issuer series, concept, and stock exchange. ```APIDOC ## GET /v2/cotizaciones ### Description Precios más recientes de la emisora y series solicitadas ### Method GET ### Endpoint https://api.databursatil.com/v2/cotizaciones ### Parameters #### Query Parameters - **token** (string) - Required - Método de autenticación - **emisora_serie** (string) - Required - Emisora con serie de la cual se solicitan las cotizaciones. Se pueden agregar separando por comas hasta 50 emisoras con serie. - **concepto** (string) - Required - Se debe elegir al menos uno de los siguientes conceptos de precios (u,p,a,x,n,c,m,v,o,i): u=ultimo, p=ppp, a=anterior, x=maximo, n=minimo, c=cambioporciento, m=cambiopesos, v=volumenoperado, o=operaciones, i=importeacumulado - **bolsa** (string) - Required - Origen de las cotizaciones. Opciones disponibles: "BMV" y/o "BIVA" ### Response #### Success Response - **[Emisora con Serie]** (string) - Clave de pizzarra (ticker) de la emisora - **bolsa** (string) - Cotizaciones de la bolsa elegida - **u** (decimal) - Último precio - **p** (decimal) - Precio Promedio Ponderado - **a** (decimal) - Precio anterior - **x** (decimal) - Precio máximo - **n** (decimal) - Precio Mínimo - **c** (decimal) - Cambio por ciento - **m** (decimal) - Cambio monetario - **v** (decimal) - Volumen operado - **o** (decimal) - Número de operaciones - **i** (decimal) - Importe acumulado - **f** (string) - Fecha de los precios ### Request Example ``` https://api.databursatil.com/v2/cotizaciones?token=TU_TOKEN&concepto=O&emisora_serie=AC*,ALFAA,ALSEA*,AMXB,ASURB,BBAJIOO,BIMBOA,BOLSAA,CEMEXCPO,CHDRAUIB,CUERVO*,FEMSAUBD,GAPB,GCC*,GENTERA*,GFINBURO,GFNORTEO,GMEXICOB,GRUMAB,KIMBERA,KOFUBL,LABB,LACOMERUBC,LIVEPOLC-1,MEGACPO,OMAB,ORBIA*,PENOLES*,PINFRA*,TLEVISACPO,VESTA*,WALMEX*&bolsa=BMV,BIVA ``` ``` -------------------------------- ### Top V2 Source: https://databursatil.com/docs.html Obtain quotes for top gainers, losers, operations, traded volume, as well as by market and exchange. ```APIDOC ## GET /v2/top ### Description Obtén cotizaciones por principales alzas, bajas, operaciones, importe operado o volumen, así como por mercado y bolsa. ### Method GET ### Endpoint https://api.databursatil.com/v2/top ``` -------------------------------- ### Downloads V2 API Source: https://databursatil.com/docs.html Provides Mexican money market valuations and end-of-day facts. ```APIDOC ## GET /v2/descargas ### Description Provides Mexican money market valuations and end-of-day facts. ### Method GET ### Endpoint /v2/descargas ### Parameters #### Query Parameters - **token** (string) - Required - Authentication method. - **archivo** (string) - Required - Specifies which document to download. Options: "hechos" (end-of-day facts) or "guber" (Mexican government money market valuations). - **fecha** (string) - Required - Specifies the date of the file to download in YYYY-MM-DD format. File dates are only available on Mexican banking business days. ### Response #### Success Response (200) - **hechos** (7z containing CSV) - End-of-day facts. - **guber** (CSV) - Daily valuations of Mexican government money market instruments. ### Request Example 1 ```json { "example": "https://api.databursatil.com/v2/descargas?token=TU_TOKEN&archivo=hechos&fecha=2025-06-02" } ``` ### Response Example 1 ```json { "example": "response body" } ``` ### Request Example 2 ```json { "example": "https://api.databursatil.com/v2/descargas?token=TU_TOKEN&archivo=guber&fecha=2025-06-02" } ``` ### Response Example 2 ```json { "example": "response body" } ``` ``` -------------------------------- ### News V2 API Source: https://databursatil.com/docs.html Fetches top business and economy headlines. ```APIDOC ## GET /v2/noticias ### Description Fetches top business and economy headlines. ### Method GET ### Endpoint /v2/noticias ### Parameters #### Query Parameters - **token** (string) - Required - Authentication method. ### Response #### Success Response (200) - **n** (string) - Headline of the news. - **c** (string) - Content of the news. - **f** (string) - Source of the news. ### Request Example ```json { "example": "https://api.databursatil.com/v2/noticias?token=TU_TOKEN" } ``` ### Response Example ```json { "example": "response body" } ``` ``` -------------------------------- ### Excel Web Service Formula Source: https://databursatil.com/docs.html Use the SERVICIOWEB formula in Excel (Spanish versions) to fetch data directly from the API. Ensure a valid token is included for the request to succeed. ```excel =SERVICIOWEB("https://api.databursatil.com/v2/cotizaciones?token=TU_TOKEN&concepto=U,P,A,X,N,C,M,V,O,I&emisora_serie=GFNORTEO&bolsa=BMV,BIVA") ``` -------------------------------- ### Version 2 Endpoints Source: https://databursatil.com/docs.html This section details the available endpoints for version 2 of the API, specifying the content returned by each. ```APIDOC ## Version 2 Endpoints ### Description Provides access to various financial market data through specialized endpoints. ### Method GET ### Endpoint - **/v2/emisoras**: Returns general information about requested issuers and their series. - **/v2/intradia**: Returns daily prices during the trading session for requested issuer-series. - **/v2/cotizaciones**: Returns the most recent prices for requested issuer-series. - **/v2/top**: Returns top issuers-series by increases, decreases, operations, volume, and/or traded amount. - **/v2/historicos**: Returns historical closing prices for a specified issuer and series. - **/v2/financieros**: Returns financial statements (financial situation, cash flows, and results) for a specified issuer and period. - **/v2/indices**: Returns the most recent prices of major international stock market indices. - **/v2/tasas**: Returns money market rates in Mexico. - **/v2/divisas**: Returns the most recent prices of major currency crosses. - **/v2/commodities**: Returns the most recent prices of major commodities. - **/v2/noticias**: Returns major daily news with an emphasis on business and financial markets. - **/v2/cables**: Returns news wires from Mexican issuers and recent news on general economy and business. - **/v2/descargas**: Returns data at the end of the day or valuations of instruments in the Mexican Money Market. - **/v2/hechos**: Returns facts filtered by day and requested issuer-series. - **/v2/creditos**: Returns available credits for the specified token. ### Base URL `https://api.databursatil.com/v2/` ### Request Example ```http GET https://api.databursatil.com/v2/emisoras ``` ### Response #### Success Response (200) - **Data**: (object) - Contains the requested financial data in JSON format. ``` -------------------------------- ### Fetch Financial Facts by Date and Issuer Source: https://databursatil.com/docs.html Retrieve financial facts for a specific date and issuer series. Ensure you replace 'TU_TOKEN' with your actual API token. ```HTTP https://api.databursatil.com/v2/hechos?token=TU_TOKEN&fecha=2025-01-24&emisora_serie=GFNORTEO&horai=09:00&horaf=09:05 ``` -------------------------------- ### Download Market Data (Hechos) Source: https://databursatil.com/docs.html Downloads market data facts for the day. Requires an authentication token, file type ('hechos'), and a specific date. ```HTTP https://api.databursatil.com/v2/descargas?token=TU_TOKEN&archivo=hechos&fecha=2025-06-02 ``` -------------------------------- ### Cables V2 API Source: https://databursatil.com/docs.html Retrieves news wires from Mexican issuers and recent general economy and business news. ```APIDOC ## GET /v2/cables ### Description Retrieves news wires from Mexican issuers and recent general economy and business news. ### Method GET ### Endpoint /v2/cables ### Parameters #### Query Parameters - **token** (string) - Required - Authentication method. - **categorias** (string) - Optional - Allows filtering by categories. Available options: "boletines", "top", "valuaciones", "flash", and/or "generales". Multiple categories can be separated by commas. ### Response #### Success Response (200) - **[categoria]** (string) - Contains the requested category. - **f** (string) - Source of the cable. - **t** (string) - Content of the cable. ### Request Example ```json { "example": "https://api.databursatil.com/v2/cables?token=TU_TOKEN" } ``` ### Response Example ```json { "example": "response body" } ``` ### Other Examples ```json { "example": "https://api.databursatil.com/v2/cables?token=TU_TOKEN&categorias=top" } ``` ```json { "example": "https://api.databursatil.com/v2/cables?token=TU_TOKEN&categorias=generales,valuaciones" } ``` ```json { "example": "https://api.databursatil.com/v2/cables?token=TU_TOKEN&categorias=boletines,top,valuaciones,flash,generales" } ``` ``` -------------------------------- ### Fetch Money Market Rates Source: https://databursatil.com/docs.html Retrieve money market rates. Use the 'ticker' parameter to filter for specific rates, separated by commas. ```http https://api.databursatil.com/v2/tasas?token=TU_TOKEN ``` ```http https://api.databursatil.com/v2/tasas?token=TU_TOKEN&ticker=CETE28 ``` ```http https://api.databursatil.com/v2/tasas?token=TU_TOKEN&ticker=TIIE91,Tasa_Objetivo ``` -------------------------------- ### Fetch Financial Facts for Multiple Issuers Source: https://databursatil.com/docs.html Retrieve financial facts for a specific date and multiple issuer series. Multiple issuers can be specified by separating them with a comma. Ensure you replace 'TU_TOKEN' with your actual API token. ```HTTP https://api.databursatil.com/v2/hechos?token=TU_TOKEN&fecha=2025-06-02&emisora_serie=GFNORTEO,ASURB&horai=10:00&horaf=10:10 ``` ```HTTP https://api.databursatil.com/v2/hechos?token=TU_TOKEN&fecha=2025-06-02&emisora_serie=AMXB,WALMEX*&horai=12%3A00&horaf=12:01 ``` -------------------------------- ### Fetch Currency Exchange Rates Source: https://databursatil.com/docs.html Retrieve prices for major currency crosses. The 'ticker' parameter can filter for specific currency pairs, separated by commas. ```http https://api.databursatil.com/v2/divisas?token=TU_TOKEN ``` ```http https://api.databursatil.com/v2/divisas?token=TU_TOKEN&ticker=EURMXN ``` ```http https://api.databursatil.com/v2/divisas?token=TU_TOKEN&ticker=USDMXN,EURMXN ``` -------------------------------- ### Fetch Financial Statement Data Source: https://databursatil.com/docs.html Retrieve specific financial statement data for a given company and period. Use the 'financieros' parameter to select the desired data points. ```http https://api.databursatil.com/v2/financieros?token=TU_TOKEN&emisora=WALMEX&periodo=1T_2023&financieros=resultado_trimestre ``` ```http https://api.databursatil.com/v2/financieros?token=TU_TOKEN&emisora=NEMAK&periodo=2T_2024&financieros=flujos,posicion,resultado_trimestre,resultado_acumulado ``` ```http https://api.databursatil.com/v2/financieros?token=TU_TOKEN&emisora=ALSEA&periodo=1T_2022&financieros=posicion,flujos,resultado_trimestre,resultado_acumulado ``` ```http https://api.databursatil.com/v2/financieros?token=TU_TOKEN&emisora=KIMBER&periodo=2T_2023&financieros=posicion ``` ```http https://api.databursatil.com/v2/financieros?token=TU_TOKEN&emisora=WALMEX&periodo=1T_2023&financieros=resultado_trimestre ``` -------------------------------- ### Intradia V2 Source: https://databursatil.com/docs.html Retrieves historical stock quotes during the trading day. Requires authentication token, issuer series, stock exchange, interval, and date range. ```APIDOC ## GET /v2/intradia ### Description Historico de cotizaciones durante la jornada bursatil. ### Method GET ### Endpoint https://api.databursatil.com/v2/intradia ### Parameters #### Query Parameters - **token** (string) - Required - Método de autenticación - **emisora_serie** (string) - Required - Emisora con serie de la cual se solicitan las cotizaciones. Se pueden agregar separando por comas hasta 10 emisoras con serie. - **bolsa** (string) - Required - Origen de las cotizaciones. Solo existen dos opciones disponibles: "BMV" y/o "BIVA". - **intervalo** (string) - Required - Frecuencia de las cotizaciones. Opciones disponibles: 1m (1 minuto), 5m (5 minutos) o 1h (1 hora). - **inicio** (string) - Required - Fecha inicial de las cotizaciones en formato AAAA-MM-DD - **final** (string) - Required - Fecha final de las cotizaciones en formato AAAA-MM-DD ### Response #### Success Response - **[Emisora con Serie]** (string) - Clave de pizzarra (ticker) de la emisora - **AAAA-MM-DD hh:mm:ss** (decimal) - Cotización de la fecha específica ### Request Example ``` https://api.databursatil.com/v2/intradia?token=TU_TOKEN&emisora_serie=ALSEA*,GFNORTEO&bolsa=BMV&intervalo=1h&inicio=2025-05-09&final=2025-05-09 ``` ``` -------------------------------- ### Fetch Stock Market Index Data Source: https://databursatil.com/docs.html Retrieve data for major stock market indices. The 'ticker' parameter can be used to filter for specific indices, separated by commas. ```http https://api.databursatil.com/v2/indices?token=TU_TOKEN ``` ```http https://api.databursatil.com/v2/indices?token=TU_TOKEN&ticker=IPC,FTSEBIVA ``` ```http https://api.databursatil.com/v2/indices?token=TU_TOKEN&ticker=SP500 ``` -------------------------------- ### Rates API Source: https://databursatil.com/docs.html Access money market rates. You can filter by specific rate tickers. ```APIDOC ## GET /v2/tasas ### Description Retrieves money market rates. Allows filtering by specific rate tickers. ### Method GET ### Endpoint /v2/tasas ### Parameters #### Query Parameters - **token** (string) - Required - Authentication method. - **ticker** (string) - Optional - Filter by selected rate. Multiple tickers can be entered separated by commas. ### Response #### Success Response (200) - **[tasa]** (string) - Money market rate. - **t** (decimal) - Rate expressed as a decimal number. - **f** (Date) - Update date in YYYY-MM-DD format. ### Request Example ```json { "example": "https://api.databursatil.com/v2/tasas?token=TU_TOKEN" } ``` ### Response Example ```json { "example": "[Response body containing rate data]" } ``` ``` -------------------------------- ### Emisoras V2 Source: https://databursatil.com/docs.html Retrieves general information about listed companies and their series, with options to filter by letter and market type. ```APIDOC ## GET /v2/emisoras ### Description Information general de las emisoras filtradas y sus respectivas series. ### Method GET ### Endpoint https://api.databursatil.com/v2/emisoras ### Parameters #### Query Parameters - **token** (string) - Requerido - Método de autenticación - **letra** (string) - Opcional - Filtra las emisoras por la letra o palabra completa ingresada - **mercado** (string) - Opcional - Permite segmentar la búsqueda solo a un tipo de mercado. Opciones disponibles: "local" y/o "global". Pueden ser agregadas ambas siendo separadas por coma. "local" se refiere a las emisoras del mercado nacional, "global" se refiere a todas las emisoras del mercado global (antes llamado SIC). ### Response #### Success Response (200) - **[Emisora]** (string) - Clave de pizzarra (ticker) de la emisora - **[Serie]** (string) - Serie de la emisora - **razon_social** (string) - Razón social de la emisora - **isin** (string) - ISIN de la emisora y serie - **bolsa** (string) - Bolsa origen de los precios - **tipo_valor_descripcion** (string) - Descripción larga del tipo valor - **tipo_valor_id** (string) - ID del tipo valor - **estatus** (string) - Situación de la emisora - **acciones_en_circulacion** (integer) - Número de acciones en circulación - **rango_historicos** (string) - Rango de fechas de precios historicos disponibles - **rango_financieros** (string) - Fechas de estados financieros disponibles - **dividendos** (JSON) - Detalle de dividendos pagados y próximo - **reciente** (string) - Contiene información del dividendo(s) más reciente o vigente - **historico** (string) - Contiene el histórico de dividendos pagados realizados o efectuados - **AAAA-MM-DD** (Fecha) - Fecha de pago del dividendo - **pago** (Decimal) - Monto de pago o canje por acción decretado por la emisora. - **tipo** (string) - Define el tipo de dividendo a pagar o canjear - **divisa** (string) - Divisa del importe por pagar o canjear - **fechaexcupon** (Fecha) - Fecha ex-cupón ### Request Example ``` https://api.databursatil.com/v2/emisoras?token=TU_TOKEN&letra=H&mercado=local ``` ### Response Example (No example provided in source) ``` -------------------------------- ### Commodities API Source: https://databursatil.com/docs.html Retrieves commodity data. You can optionally filter by ticker symbol. ```APIDOC ## GET /v2/commodities ### Description Retrieves commodity data. You can optionally filter by ticker symbol. ### Method GET ### Endpoint /v2/commodities ### Parameters #### Query Parameters - **token** (string) - Required - Authentication method. - **ticker** (string) - Optional - Filter by ticker symbol. Multiple tickers can be separated by commas. ### Response #### Success Response (200) - **[commodity]** (string) - Name of the commodity. - **ytd** (decimal) - Year-to-date percentage change. - **yoy** (decimal) - Year-over-year percentage change. - **t** (date) - Update date in YYYY-MM-DD format. - **u** (decimal) - Last price. - **x** (string) - Commodity unit of measure. - **m** (decimal) - Monetary change. - **p** (decimal) - Percentage change. - **l** (decimal) - Current month percentage change. - **s** (decimal) - Current week percentage change. - **f** (date) - Update date in YYYY-MM-DD format. ### Request Example ```json { "example": "https://api.databursatil.com/v2/commodities?token=TU_TOKEN" } ``` ### Response Example ```json { "example": "response body" } ``` ```