webservice

  1. J

    Missing Pieces of my Puzzle!! Please Help!!

    Can somebody help me fill in the green column. Please also put what is missing the the formula and show me where to put the correct functions in row 1 too. I was using Clearbit V1 API. initially. GET https://autocomplete./companies/suggest?query= name...
  2. B

    Automate a Cell Value from TRUE to FALSE at a Set Interval of Time

    I've done a bunch of research, and I'm not sure a solution exists for this challenge -- but I would be grateful for any input from the forum. I have a sheet that displays financial news that is accessed from a 3rd party data vendor using Excel WEBSERVICE calls. The sheet works fine, but the...
  3. R

    Excel 2013 - WEBSERVICE and FILTER XML

    Trying to pull the Manufacturing cost index from an XML pull. The XML comes from https://api.eve-industry.org/system-cost-index.xml?name=Osmon I successfully used the WEBSERVICE function in excel to create and pull the data; <CODE>B2 = Above Link, C2 = System name (i.e. Osmon)</CODE><CODE>...
  4. R

    Speed up excel webservice() formula

    Hi everyone, I currently have a stock list with various information for each stock (8 columns) being retrieved using WebService(). The problem is that my stock list contains 2000 stocks. This often takes a very long time in excel. I am wondering whether there is a VBA method of speeding this...
  5. A

    Weather Information into Excel using Openweather API Filterxml Webservice

    hi Need help with the following; it is clearly beyond me ! I have an API for openweather.org I can Paste the API info into a Browser and get a response back that looks like this; Webinfo...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top