Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultants - New Web Query.

excel consultants - New Web Query.

ResolvedVersion Standard

Tue 23 Jan 2007, 07:57 Delegate Stephen said...

Stephen has attended:
Excel Intermediate course

New Web Query.

Hi,

I would like to import a web query on a website which streams live prices of the FTSE markets and other UK markets.

Is there some way in which I can import this data and have it refresh in real time when the market moves?

Thanks very much for your help.

Stephen.

Tue 23 Jan 2007, 12:14 Trainer Richard said...

RE: New Web Query.

Copy and paste static data or a refreshable query

You can use familiar copy and paste commands to bring the data from a Web page into an Excel worksheet. When you paste Web page data into Excel, you can keep the data static or make it refreshable by clicking Paste Options and clicking Create Refreshable Web Query.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Create Equations in Excel 2010

Here's how to create basic mathematical
equations in your Excel 2010 worksheet.

1) On the Ribbon, click the Insert tab
2) In the Symbols group, click the arrow next to Equation
3) Select from the equations and the equation will be inserted in a text box

Or you can create your own equation:

1) Insert and select the text box
2) On the Ribbon, click the Insert tab
3) In the Symbols group, click Equation
4) The Equation Tools Design Ribbon will now be displayed

View all Excel hints and tips

excel consultants - New Web Query.

New Web Query.

RE: New Web Query.

Excel articles

Excel tip:

Create Equations in Excel 2010