excel consultants - new web query

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

excel consultants - New Web Query.

resolvedResolved · Low Priority · Version Standard

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.

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

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


Server loaded in 0.09 secs.