Messtone LLC Site Title

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…

Messtone Devices Enables Python(using Request module) import request base_currency=’USD’ symbol=’XAU’ endpoint=’latest’ access_key=’API_KEY’ resp=requests.get(‘https://www.commodities-api.com/api/’+endpoint+’?access_key=’+access_key+’&base=’+base_currency+’&symbols=’+symbol) if resp.status_code !=200:#This means something went wrong.raise ApiError(‘GET /’+endpoint+’/{ }’.format(resp.status_code))print(resp.json( )) JavaScript(jQuery.ajax) getting exchange rates data via,latest endpoint`//set endpoint and Messtone access key endpoint=’latest’ access_key=’API_KEY’;//get the most recent exchange rates via the “latest” endpoint:$.ajax({url:’https://www.commodities-api.com/api/’+endpoint+’?access_key=’+access_key,dataType:’jsonp’,success: function(json){//exchange rata data is stored in json.rates alert(json.rates.GBP);//base…

Messtone Devices Enables Open/High/Low/Close(OHLC) Price Endpoint API request: https://www.commodities-api.com/open-high-low-close/YYYY-MM-DD?access_key=API_KEY & base=USD & symbols=XAU API Response:{“success”:true,”timestamp”:1653931700,”date”:”2022-05-20″,”base”:”XAU”,”symbol”:”USD”,”rates”:{“open”:0.00054346155,”high”:0.00054646956,”low”:0.000540054,”close”:0.00054174699447635},”unit”:”per ounce”} via the Commodities-APIs latest endpoint: //set API Endpoint and API key $endpount=’latest’;$access_key=”API_KEY”;//Initialize CURL:$ch=curl_init(‘https://www.commodities-api.com/api/’.$endpoint.’?access_key=’.$access_key.’ ‘);curl_setopt($ch, CURL_OPT_RETURNTRANSFER,true);//Store the data:$json=curl_exec($ch);curl_close($ch);//Decode JSON response:$exchangeRates=json_decode($json,true);//Access the exchange rate values, e.g.GBP;echo $exchangeRates[‘rates’][‘GBP’];Convert currencies:Here is how to convert currencues using PHP cURL //set API Endpoint, access key,required…

Messtone Devices Enables LSEG workflow qj Email query: {“ExtractionRequest”:{“@odata.type”:”#Data Scope.Select.Api.Extractions.ExtractionRequestsIntradayPricingExtractionRdquest”,”ContentFieldNamesMesstone”:[“RIC”,Ask Price”,”Bid Price”,”Trade Date”],”IdentifierList”:{“@odata.type”:”#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList”:[{“Identifier”:”EUR”,”IdentifierType”:”Ric”},{“Identifier”:”GBP”:”IdentifierType”:”Ric”}]]},”Condition”:”ScalableCurrency:true}}} Example Response {“@odata.context”:”https://selectapi.scope.refinitiv.com/RestApi/v1/$metadata#Collection(DataScope.Select.Api.Extractions.ExtractionRequests.ExtractionRow)”,”value”:[{“IdentifierType”:”Ric”,”Identifier”:”EUR=”RIC”:”EUR=”,”Ask Price”:1.0706,”Bid Price”:1.0704,”Trade Date”:”2022-05-25″},{“IdentifierType”:”Ric”,”Identifier”:”GBP=”RIC”:”GBP=”RIC”:”GBP”,”Ask Price”:1.2532,”Trade Date”:”2022-05-25″}]}