Enterprise X


EnterpriseX is a server to server distribution medium for QuoteMedia's financial data via Request API. The system is designed to provide intraday snap information and end of day bulk information to authorized users (IP, Token, User Session). EnterpriseX operates as a polled data source using http for the transport and XML or JSON for the encoding.


Access Control


Request Structure:
The requests are simple http get requests on port 80 to app.quotemedia.com (West Coast) or quotes.quotemedia.com (East coast) which you pass a set of parameters to configure the response you want to receive. Request API Data Center Failover Protocols.


The request uses the Restful BEST Practices, for more details click here


Response Structure:
The response to the request is an XML or JSON document containing the data. 


IPOsByCountry


The IPOsByCountry API provides the ability to search for all companies that have had an IPO within a specified time frame. IPOs for US and Canada are supported with historical data starting from January 2021.


Please note that API requests for an entire country tend to return file sizes too large to be processed by internet browsers.




Output


 

Fields
Data Type
Description
pageNumberIntegerPage number
totalPagesIntegerTotal number of pages
nextPageStringURL of next page
copyrightStringQuoteMedia copyright
countryStringCountry for requested data.  
offeringStartDateDate (YYYY-MM-DD)Start date of the date range being accessed
offeringEndDateDate (YYYY-MM-DD)End date of the date range being accessed
offerings
Section header
offertypeStringThe type of public listing occurring. output = IPO, SPAC [Special Purpose Acquisition Company], DL [Direct Listing].
offerStatusStringThe status of the offer from the issuer. output = Open/ Closed
listingStatusStringListing Status. output = Listed/ listing pending
useofproceedsStringDescription of what the capital funding will be used for.
offeringAnnouncementDateDate (YYYY-MM-DD)The date the offer was announced.
offeringPriceAnnouncementDateDate (YYYY-MM-DD)The announcement date the Offer Price (AKA Issue Price, IPO Price).
offeringStartDateDate (YYYY-MM-DD)IPO offering start date
offeringEndDateDate (YYYY-MM-DD)IPO offering end date
shareIssueDateDate (YYYY-MM-DD)Date when share issued
strategicSharesOfferedDate (YYYY-MM-DD)Strategic shares offered
underwritingDiscountFloatDiscount given to the underwriters, amount per unit.
proceedsAfterExpensesFloatPart of price which remains after expenses
shareholderSharesOfferedIntegerNumber of shares which shareholder released
lockupPeriodIntegerPeriod of time for which shares cannot be sold by company insiders after Public Listing.
lockupExpirationDateDate (YYYY-MM-DD)End date of lockup period.
quietPeriodExpirationDateDate (YYYY-MM-DD)Quiet period expiration date
numberOfSharesIssuedIntegerTotal number of shares issued
strategicSaleOfferThatWereIssuedIntegerStrategic shares issued
greenshoeOptionExerciseDateDate (YYYY-MM-DD)Greenshoe Option Exercise Date
totalOfferingExpenseFloatTotal offering expense
numberOfGreenshoeSharesIntegerNumber of Greenshoe Shares underwriter could subscribe to
dateOfFilingDate (YYYY-MM-DD)Date on which first filing related to offering submitted to SEC, SEDAR, FCA by company.
expectedOfferingStartDateDate (YYYY-MM-DD)Anticipated/forecasted date for IPO offering start date
offerAmountMinIntegerMinimum forecasted total value of the securities being issued in the event
offerAmountMaxIntegerMaximum forecasted total value of the securities being issued in the event
sharesOverAllottedIntegerNumber of shares allotted above original offerings. AKA Greenshoe shares.
registrationFeeFloatFees need to pay registration
typeOfEquityInstrumentStringType of instrument being issued. Output can be custom, but typically includes:
Class A/B Common Shares
Warrants
Options
Subscription Receipts
Debt Securities
Units
American Depositary Shares (ADS)
 Preferred Shares
warrantsIssuedFloatWarrants issued
legalFeesExpenseFloatLegal Fees Expenses
securityParvalueFloatNominal or par value of the security issued
expriceOfWarrantsFloatExercise Price of Warrants
expectedDateOfListingDate (YYYY-MM-DD)Anticipated or Forecasted Date of Listing/First Day of Trading, based on latest SEC Filings.
symbolStringSymbol
companyNameStringcompany
exchangeStringListing Exchange of company/symbol
currencyStringThe currency of the security (which can differ from the country)
offerPriceFloatFinal price at which the issuer offers their securities to the investors participating in the IPO. AKA issue price, IPO price.
priceRangeMaxFloatHighest offer price forecast pre-IPO
priceRangeMinFloatLowest offer price forecast pre-IPO
SharesOfferedIntegerMinimum shares offered during IPO
dateOfListingDate (YYYY-MM-DD)Date the securities begin trading on exchange. First Trading Date.
offerAmountFloatThe total value of the securities being issued in the event. Calculated as offer price x shares
statusStringStatus of the event overall
C= Cancelled
F= Filing
U=Upcoming
A= Announced
L= Postponed
W= Withdrawn
T=Trading
R= Rumour
P= Pending
N= New
H= History
leadUnderwriterStringLead IPO underwriter
underwriterStringIPO underwriter
underwriterCounselStringUnderwriter Counsel
companyCounselStringLaw firm company name
transferAgentstringTransfer Agent name
openingPricestringOpening price of security


Our intention is to output a field only when it has a value to be displayed so null or empty will not display


Input 

Fields

Required

Default

Range of Values

Description

country

Yes (either country or symbol is required)

US

Type: Text

Country Codes:
us = United States
ca = Canada

Country for requested data.  Cannot be used with the symbol input parameter.

current

No

current date

date(YYYY-MM-DD)

Enter in the date for requested data or with no input the most recent symbol change will display.

start

No

none

date(YYYY-MM-DD)

Allows for the specification of a start date. Accepted format is YYYY-MM-DD historical data starting from December 2020. 

end

No

none

date(YYYY-MM-DD)

Allows for the specification of an end date. Accepted format is YYYY-MM-DD. Must be used in conjunction with the start input parameter.

page

No

1

Unlimited

Page number of query results

results_per_page

No

none

Unlimited

Number of records to show per page

exclude

No

S

any output data point

Allows for the exclusion of specific data points (Up to a maximum of 5). Ex. When exclude=open is used, all open values will be hidden in the output.

webmaster_id

Yes

none

Numeric value

QuoteMedia attaches a unique id to your company that allows us to entitle you to specific data and products

content_type

No

json

Type: Text - json or xml

Format of output

unscheduledNofalsetrue/falseAllows for the inclusion of upcoming ipo records that do not yet have a dateOfListing provided
include_nullsNononetrue/falseWhen set to true, null value fields will be included in the output.
fieldsNononeString

The fields input parameter allows to define which fields you want to include in the output and which ones you don't.


If the field isn't nested, it can be included directly. If it is nested then it will need to use syntax such as - object1[fieldX,fieldY]


If excluding specific fields, start the request with a '!'. If excluding a nested field then use syntax such as - !object1[fieldX,fieldY]


For a more detailed explanation please see this article here

offer_type
NoAllIPO, DL, SPAC, ALL
Defines the type of Public Listing you wish to have



Sample Request - IPOsByCountry

This API brings back IPOsByCountry Data for the United States in JSON

Browser Requesthttps://app.quotemedia.com/v2/events/ipos?webmaster_id=XXXXX&content_type=json&start=2021-12-01&end=2021-12-30&country=us&results_per_page=10&page=1


User-based Session Request  - http://app.quotemedia.com/v2/events/ipos?webmaster_id=XXXXX&content_type=json&start=2021-09-01&end=2021-09-30&country=us&results_per_page=10&page1&sid=[extracted_sid]


This API brings back IPOsByCountry Data for the United States in XML

Browser Request - http://app.quotemedia.com/v2/events/ipos?webmaster_id=XXXXX&content_type=xml&start=2021-09-01&end=2021-09-30&country=us&results_per_page=10&page=1



Sample Result - IPOsByCountry - JSON


Results based on

https://app.quotemedia.com/v2/events/ipos?webmaster_id=XXXXX&content_type=json&start=2021-12-01&end=2021-12-30&country=us&results_per_page=10&page=1


*results limited to show only the first few results

{"results": {"pageNumber": 1,"totalPages": 7,"nextPage": "https://app.quotemedia.com/v2/events/ipos?webmaster_id=91924&content_type=json&start=2021-12-01&end=2021-12-30&country=us&results_per_page=10&page=2","copyright": "Copyright (c) 2022 QuoteMedia, Inc.","country": "US","offerings": [{"offerType": "SPAC","listingStatus": "Listed","useOfProceeds": "Gross proceeds of the offerings will be 104,760,000 out of which underwriting commission and offering expenses will be paid . The remaining funds are kept in trust account which can be use for purchasing target company or other general corporate purposes.","offeringAnnouncementDate": "2021-06-09","offeringPriceAnnouncementDate": "2021-12-29","offeringStartDate": "2021-12-30","offeringEndDate": "2022-01-03","underwritingDiscount": 0.55,"proceedsAfterExpenses": 9.45,"lockupPeriod": 180,"lockupExpirationDate": "2022-06-28","quietPeriodExpirationDate": "2022-02-08","totalOfferingExpense": 660000,"numberOfGreenshoeShares": 1500000,"dateOfFiling": "2021-07-21","expectedOfferingStartDate": "2021-12-30","offerAmountMin": 100000000,"registrationFee": 12547,"typeOfEquityInstrument": "Units","warrantsIssued": 5238000,"legalFeesExpenses": 225000,"securityParvalue": 0.0001,"expriceOfWarrants": 11.5,"symbol": {"symbol": "GMFIU","companyName": "Aetherium Acquisition Corp","exchange": "NSD","currency": "USD"},"offerPrice": 10,"priceRangeMax": 10,"priceRangeMin": 10,"sharesOffered": 10000000,"dateOfListing": "2021-12-30","offerAmount": 100000000,"status": "T","underwriter": "EF Hutton division of Benchmark Investments LLC","lawFirm": "Loeb & Loeb LLP","transferAgent": "Continental Stock Transfer & Trust Company","openingPrice": 10},{"offerType": "IPO","offerStatus": "Closed","listingStatus": "Listed","useOfProceeds": "The principal purposes of this offering are to obtain additional working capital, to create a public market for our ordinary shares and to facilitate our future access to the public equity markets.","offeringAnnouncementDate": "2020-09-30","offeringPriceAnnouncementDate": "2021-01-27","offeringStartDate": "2021-01-28","offeringEndDate": "2021-02-01","underwritingDiscount": 1.14,"proceedsAfterExpenses": 13.86,"lockupPeriod": 180,"lockupExpirationDate": "2021-07-27","quietPeriodExpirationDate": "2021-03-09","totalOfferingExpense": 4064630,"numberOfGreenshoeShares": 2175000,"dateOfFiling": "2020-12-30","offerAmountMin": 217500000,"typeOfEquityInstrument": "Common Shares","legalFeesExpenses": 1150000,"securityParvalue": 0.03,"symbol": {"symbol": "ZIM","companyName": "ZIM Integrated Shipping Services Ltd","exchange": "NYE","currency": "USD"},"offerPrice": 15,"priceRangeMax": 15,"priceRangeMin": 15,"sharesOffered": 14500000,"dateOfListing": "2021-12-28","offerAmount": 217500000,"status": "T","underwriter": "Jefferies LLC,Goldman Sachs & Co LLC,Clarksons Platou Securities Inc,Citigroup Global Markets Inc,Barclays Capital Inc","lawFirm": "Davis Polk & Wardwell LLP","transferAgent": "Action Stock Transfer Corporation","openingPrice": 8.433648},


Sample Result - IPOsByCountry - XML


Results based on

https://app.quotemedia.com/v2/events/ipos?webmaster_id=XXXXXX&content_type=XML&start=2021-12-01&end=2021-12-30&country=us&results_per_page=10&page=1


*results limited to only show the first few results

a.com/v2/events/ipos?
<results pageNumber="1" totalPages="7" nextPage="https://app.quotemedia.com/v2/events/ipos?webmaster_id=91924&content_type=xml&start=2021-12-01&end=2021-12-30&country=us&results_per_page=10&page=2">
<copyright>Copyright (c) 2022 QuoteMedia, Inc.</copyright>
<country>US</country>
<offerings>
<offering>
<offerType>SPAC</offerType>
<listingStatus>Listed</listingStatus>
<useOfProceeds>Gross proceeds of the offerings will be 104,760,000 out of which underwriting commission and offering expenses will be paid . The remaining funds are kept in trust account which can be use for purchasing target company or other general corporate purposes.</useOfProceeds>
<offeringAnnouncementDate>2021-06-09</offeringAnnouncementDate>
<offeringPriceAnnouncementDate>2021-12-29</offeringPriceAnnouncementDate>
<offeringStartDate>2021-12-30</offeringStartDate>
<offeringEndDate>2022-01-03</offeringEndDate>
<underwritingDiscount>0.55</underwritingDiscount>
<proceedsAfterExpenses>9.45</proceedsAfterExpenses>
<lockupPeriod>180</lockupPeriod>
<lockupExpirationDate>2022-06-28</lockupExpirationDate>
<quietPeriodExpirationDate>2022-02-08</quietPeriodExpirationDate>
<totalOfferingExpense>660000</totalOfferingExpense>
<numberOfGreenshoeShares>1500000</numberOfGreenshoeShares>
<dateOfFiling>2021-07-21</dateOfFiling>
<expectedOfferingStartDate>2021-12-30</expectedOfferingStartDate>
<offerAmountMin>100000000</offerAmountMin>
<registrationFee>12547</registrationFee>
<typeOfEquityInstrument>Units</typeOfEquityInstrument>
<warrantsIssued>5238000</warrantsIssued>
<legalFeesExpenses>225000</legalFeesExpenses>
<securityParvalue>0.0001</securityParvalue>
<expriceOfWarrants>11.5</expriceOfWarrants>
<symbol>
<symbol>GMFIU</symbol>
<companyName>Aetherium Acquisition Corp</companyName>
<exchange>NSD</exchange>
<currency>USD</currency>
</symbol>
<offerPrice>10</offerPrice>
<priceRangeMax>10</priceRangeMax>
<priceRangeMin>10</priceRangeMin>
<sharesOffered>10000000</sharesOffered>
<dateOfListing>2021-12-30</dateOfListing>
<offerAmount>100000000</offerAmount>
<status>T</status>
<underwriter>EF Hutton division of Benchmark Investments LLC</underwriter>
<lawFirm>Loeb & Loeb LLP</lawFirm>
<transferAgent>Continental Stock Transfer & Trust Company</transferAgent>
<openingPrice>10.0</openingPrice>
</offering>
<offering>
<offerType>IPO</offerType>
<offerStatus>Closed</offerStatus>
<listingStatus>Listed</listingStatus>
<useOfProceeds>The principal purposes of this offering are to obtain additional working capital, to create a public market for our ordinary shares and to facilitate our future access to the public equity markets.</useOfProceeds>
<offeringAnnouncementDate>2020-09-30</offeringAnnouncementDate>
<offeringPriceAnnouncementDate>2021-01-27</offeringPriceAnnouncementDate>
<offeringStartDate>2021-01-28</offeringStartDate>
<offeringEndDate>2021-02-01</offeringEndDate>
<underwritingDiscount>1.14</underwritingDiscount>
<proceedsAfterExpenses>13.86</proceedsAfterExpenses>
<lockupPeriod>180</lockupPeriod>
<lockupExpirationDate>2021-07-27</lockupExpirationDate>
<quietPeriodExpirationDate>2021-03-09</quietPeriodExpirationDate>
<totalOfferingExpense>4064630</totalOfferingExpense>
<numberOfGreenshoeShares>2175000</numberOfGreenshoeShares>
<dateOfFiling>2020-12-30</dateOfFiling>
<offerAmountMin>217500000</offerAmountMin>
<typeOfEquityInstrument>Common Shares</typeOfEquityInstrument>
<legalFeesExpenses>1150000</legalFeesExpenses>
<securityParvalue>0.03</securityParvalue>
<symbol>
<symbol>ZIM</symbol>
<companyName>ZIM Integrated Shipping Services Ltd</companyName>
<exchange>NYE</exchange>
<currency>USD</currency>
</symbol>
<offerPrice>15</offerPrice>
<priceRangeMax>15</priceRangeMax>
<priceRangeMin>15</priceRangeMin>
<sharesOffered>14500000</sharesOffered>
<dateOfListing>2021-12-28</dateOfListing>
<offerAmount>217500000</offerAmount>
<status>T</status>
<underwriter>Jefferies LLC,Goldman Sachs & Co LLC,Clarksons Platou Securities Inc,Citigroup Global Markets Inc,Barclays Capital Inc</underwriter>
<lawFirm>Davis Polk & Wardwell LLP</lawFirm>
<transferAgent>Action Stock Transfer Corporation</transferAgent>
<openingPrice>8.433648</openingPrice>
</offering>