Today we will discuss how to load data from the web.

Create a new workbook and click Wizards, Connection Wizard.

In the first page, select Gartle Web Data Provider and click Next.

In the next step, fill in the URL field.

In this example, select the Yahoo Finance chart data URL and wait several seconds.

The add-in will detect and fill the service URL.

Pay attention to the {Symbol=AAPL} insertion.

You may define query parameters in this way.

The add-in places the Symbol parameter at the ribbon and replaces the insertion with a parameter value.

AAPL is a default value of the parameter in this example.

When you click Finish, you may see and change query parameters. Click OK.

$B$3 is the default address to insert. This allows using row 2 to change auto-filters.

Here is a connected table with historical stock prices from Yahoo Finance:

You may refresh data and change query parameters using the ribbon.

You may format columns and add your formulas. The add-in keeps this.

You may create and apply table views as we discussed earlier.

Moreover, you may use Publish Wizard to create a database table based on loaded data, Data Merge Wizard to merge data for the first time, and the Save, Merge button to merge data later in one click.

Best regards,

Sergey Vaselenko
CEO | Gartle Technology Corporation

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.