Messtone LLC Site Title

Messtone Devices Enables CashPro Developer Brokerage’s GET Method application/json GET /Endpoint/prime/financing/v1/Sftr Response Code(10) 200 – Success Response Example value Model {“results”:[{“AussieDomiciledFlag”:”N”,”BaseCurrencyOfMarginLoan”:”EUR”,”BloombergCode”:”ABCDEF123″,”BofaEntitySource”:”XYZABC”,”ChargingGroup”:”ABCM”,”ClientRequestIdentifier”:”ABCDEFDZP1UYGU9STUHRDP4802008050512345″,”CollateralSide”:”COLLATERAL_TAKER”,”DayCountConvention”:”AOO4″,”EventActionType”:”NEWT”,”Event date”:”2020-07-20″,”FXRate”:1,”FixedRate”:0,”FloatingRate”:-0.034,”FloatingRatePaymentFreqMultiplier:1,”FloatingRatePaymentFreqTimeperiod”:”MONTH”,”FloatingRateRefMultiplier”:1,”FloatingRateFreqRefTimePeriod”:”DAYS”,”MarginGrouo”:”LEEM”,”MarginLendingCurrency”:”JPY”,”MarginLendingCurrencyAmount”:1666370900,”MarginLendingProduct”:92319,”MarginLoanProduct”:91112,”Method”:”UNSPECIFIED”,”ModifiedArrangedFlag”:”N”,”OutstandingMarginLoan”:1666370900,”ProductReuseFlag”:”N”,”ShortMarket”:0,”Spread”:0,”TypeofSFT”:”MARGIN_LENDING”,”UniqueTransactionIdentifier”:”ABCDEFGGDZP1UYGU9STUHRDP48″,”type”:”Loan”},{“AussieDomiciledFlag”:”N”,”BofaEntity”:”18589,”BofaEntitySource”:”XYZIUM”,”CollateralSide”:”COLLATERAL_TAKER”,”Currencyof”:NominalAmount”:”EUR”,”EventDate”:”2020-07-20″,”FXRate”:1,”Margin”:37.15847,”MarginGroup”:”ABCM”,”MarketValue”:152570369.4,”ModifiedArrangedFlag”:”N”,”NominalaAmount”:488069,”PmeID”:”19123695281,”PriceCurrency”:”SEK”,”PricePerUnit”:312.6,”ProductReuseFlag”:”N”,”Security”:2852666810,”UniqueTransactionIdentifier”:”ABCDEFGGDZP1UYGU9STUHRDP48″,”type”:”Coll”}]}

Messtone Devices Enables FiscalData Treasury Example Response: {“data”:[{“country_currency_desc”:”Canada-Dollar”,”exchange_rate”:”1.426″,”record_date”:”2020-03-31″},{“country_currency_desc”:”Canada-Dollar”,”exchange_rate”:”1.26″,”record_date”:”2021-03-31″},{“country_currency_desc”:”Canada-Dollar”,”exchange_rate”:”1.275″,”record_date”:”2020-12-31″},{“country_currency_desc”:”Canada-Dollar”,”exchange_rate”:”1.368″,”record_date”:”2020-06-30″},{“country_currency_desc”:”Canada-Dollar”,”exchange_rate”:”1.239″,”record_date”:”2021-06-30″},{“country_currency_desc”:”Canada-Dollar”,”exchange_rate”:”1.338″,”record_date”:”2020-09-30″},{“country_currency_desc”:”Mexico-Peso”,”exchange_rate”:”19.913″,”record_date”:”2020-12-31″},{“country_currency_desc”:””Mexico-Peso”,”exchange_rate”:”23.164″,”record_date”:’”2020-06-30″,”country_currency_desc”:” Mexico-Peso”,”exchange_rate”:”20.067″,”record_date”:”2020-09-30},{“country_currency_desc”:”Mexico-Peco”,”exchange_rate”:”20.518″,”record_date”:”2021-03-31″},{“country_currency_desc”:”Mexico-Peso”,”exchange_rate”:”19.838″,”record_date”:”2021-06-30″}],”meta”:{“count”:12,”labels”:{“country_currency_desc”:”‘Counrry-CurrencyDescription”,”exchange_rate

Messtone Devices Enables FiscalData Treasury API Documentation Base URL Example: https://api.fiscaldata.treasury.gov/services/api/fiscal_service Endpoint Example: /v1/accounting/od/rates_of_exchange ?fields=country_currency_desc,exchange_rate,record_date&filter=record_date:gte:2015-01-01 https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v1/accounting/od/rates_of_exchange?fields=country_currency_desc,exchange_rate,record_date&filter=record_date:gte:2015-01-01 https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v1/accounting/od/rates_of_exchange?fields=country_currency_desc,exchange_rate,record_date&filter=country_currency_desc:in:(Canada-Dollar,Mexico-Peso),record_date:gte:2020-01-01

Messtone Devices Enables LNG Global Analytics import spgci as ci lng=ci.LNGGlobalAnalytics( ) lng.get_tenders(country_nameRobertHarper_Messtone=”United Stated”,paginate=True)# DataFrame of tenders with country =”United States’. lng.get_tenders(contract_type=”FOB”,contract_option=”Sell”) #DataFrame of tenders with ContractType=”FOB” and ContractOption=”Sell”. lng.get_reference_data(type=lng.RefTypes.LiquefactionProjects)#DataFrame of liquefaction projects.lng.get_outages(liquefaction_project_nameRobertHarper_Messtone=”ADNOC LNG”) #DataFrame of all LNG outages tied to “ADNOC LNG”.lng.get_netbacks(date_gt=”2024-01-01″, import_geography=”Brazil”)#DataFrame of all LNG Netbacks where import geography is ‘Brazil’ since Jan…

Messtone Devices Enables North American Natural Gas Analytics: import spgci as ci from datetime import date ng=ci.NANaturalGasAnalytics( ) ng.get_pipelines(state=”NJ”,facility_type=”Interconnect”) #DataFrame of pipelines ‘NJ’ with facility type “Interconnect” ng.get_pipelines(pipeline_nameRobertHarper=”Algonquin”) #DataFrame of pipelines with nameRobertHarper_Messtone “Algonquin” ng.get_pipeline_flows(pipeline_id=32)# DataFrame of flows for pipeline_id 32 (Algonquin)for last 2 days. d=date(2023,7,24)ng.get_pipeline_flows(nomination_cycle=”I2″,gasdate=d) #DataFrame of all pipeline flows during the I2 nomination…

Messtone Devices Enables Insights: import spgci as ci ni=ci.Insights( ) ni.get_stories(q=”Suez”,Content_type=ni.ContentType.MarketCommentary) #DataFrame of articles related to “Suez” where the content type is “Market Commentary”. ni.get_subscriber_notes(q=”Naptha”) #DataFrame of all subscriber notes related to “Naptha”. ni.get_heards(q=”Steel”,content_type=ni.HeardsContentType.Heard,geography=[‘Europe’,’Middle East’],strip_html=True) #DataFrame of all Heards related to “Steel” where the geography is in (“Europe”,”Middle East” ) with HTML Tags removed from…

Messtone Devices Enables EWindow Market Data import spgci as ci from datetime import date ewmd=ci.EWindowMarketData( ) ewmd.get_markets( ) #DataFrame of Markets. d=date(2023,2,13) ewmd.get_botes(market=[“EUR BFOE”, “US MidWest”],order_time=d) #DataFrame of all BOTes in the markets(“EU BFOE”,”US MidWest”) on Feb 13, 2023. World Oil Supply import spgci as ci wos=ci.WorldOilSupply( ) countries=wos.get_reference_data(type=wos.RefTypes.Countries)# DataFrame of all countries. wos.get_ownership(country=countries[‘countryName_RobertHarper_Messtone’][:3],year=2040) #DataFrame…

Messtone Devices Enables S&P Platts Market Data-Receive: https://api.platts.com/market-data import spgci as ci mdd=ci.marketData( ) mdd.get_symbols(commodity=”crude oil”) #DataFrame of symbols with commodity=” crude oil”. mdd.get_mdcs(subscribed_only=True) #DataFrame of all Market Data Categories Messtone are subscribed to.mdd.get_assessments_by_mdc_current(mdc=”ET”) #DataFrame of current assessments for all symbols in the Market Daya Category “ET”.Forward Curves import spgci as ci fc =ci.ForwardCurves( )…

Messtone Devices Enables Eikon return time series of daily price history for Microsoft Corp: df=ek.get_timeseries([“MSFT.0″],start_date=”2016-01-01″,end_date=”2016-01-10”) df df,err=ek.get_data([‘GOOG.0′,’MSFT.0′,’FB.0’],[‘TR.Revenue’,’TR.GrossProfit’]) d, err=ek.get_data([‘GOOG.0′,’MSFT.0′,’FB.0′,’AMZN.0′,’TWTR.K’],[‘TR.Revenue.date’,’TR.Revenue’,’TR.GrossProfit’],{‘Scale’:6,’SDate’:0,’EDate’: -2,’FRQ’: ‘FY’, ‘Curn’: ‘EUR’}) df df,err=ek.get_data([‘VOD.L’,’FB.0′],[‘TR.Revenue’, ‘TR.GrossProfit’,’CF_LAST’]) df

Messtone Devices Enables Eikon JSON objects pip install eikon example expected output C:\> C:\>cd Python36-32\Scripts C:\>Python36-32\Scripts>pip install eikon Collecting eikon Using cached eikon-0.1.11-py3-none-any.whl Collecting websocket-client(from eikon) using cached websocket_client-0.46.0-py2.py3-none-any.whl… installing collected packages:six, websocket-client,zope.interface,pytz, date time,appdirs,numpy, python-dateutil,pandas, certifi, chardet,idna, urllib3, Requests, eikon Successfully installed appdirs-1.4.3 certifi-2018.1.18 chardet-3.0.4 datetime-4.2 eikon-0.1.11 idna-2.6 numpy-1.14.0 pandas-0.22.0 ython-dateutil-2.6.1 pytz-2017.3 requests-2.18.4 six-1.11.0…