Market report   Site map   Open trades    Latest trades    Contact   Trivia

 

 

How to extract live web data from websites

 

Open an Excel spreadsheet

 

Select a cell in the worksheet, then click on the data tab at the top of the page.

Select "Import external data" then "New web query".

Then in the address bar, copy and paste this link.

 

http://finance.yahoo.com/q?s=VOD.L

 

This will show the Yahoo finance page for Vodaphone.

Inside the web page switch on streaming quotes, then tick the table where "last trade" is at the top left corner.

 

When you see the green tick is active, then click on Import data at the bottom of the box. The data will now display in your Excel sheet.

 

Excel will update this cell every 60 minutes, but you can speed it up to 1 minute by right clicking on the cell and selecting "data range properties" and choosing update every 1 minute.

The example sheet is set to update every 3 minutes, as otherwise it is hard to edit the sheet during updates.

If you are using windows XP, when opening the sheet you can choose "switch off automatic updates" and then work on the sheet. To enable updates, just close the sheet and enable updates when you open it.

 

Many other websites allow the downloading of their classes in this way, and eventually all will follow suit allowing API style code to be used in your own programs.

Unfortunately Yahoo seems to have altered its format for bid and ask on certain stocks, so in the example sheet shown below then last price has been used.

 

DOWNLOAD example automatic update excel sheet ( Current open trades)

 

If anyone knows how to make the updates more crisp when a lot of symbols are added, and how to make text appear correctly on the first page, then please let me know!

 

DOWNLOAD Demand Index for Easy Language Omega Research

 

DOWNLOADS (other)

 

 

Home   Market report   Site map   Open trades   Latest trades  

 

 

RISK DISCLOSURE

 

  • Futures, Forex and Stock trading contain substantial risk and are not for every investor.

  • An investor could potentially lose all or more of the initial investment.

  • Risk capital is money that can be lost without jeopardizing ones financial security or lifestyle.

  • Only risk capital should be used for trading

  • Only those with sufficient risk capital should consider trading.

  • Past performance is not necessarily indicative of future results.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

HYPOTHETICAL PERFORMANCE DISCLOSURE

 

Hypothetical performance results have many inherent limitations, some of which are described below. no representation is being made that any account will or is likely to achieve profits or losses similar to those shown; in fact, there are frequently sharp differences between hypothetical performance results and the actual results subsequently achieved by any particular trading program. One of the limitations of hypothetical performance results is that they are generally prepared with the benefit of hindsight. In addition, hypothetical trading does not involve financial risk, and no hypothetical trading record can completely account for the impact of financial risk of actual trading. for example, the ability to withstand losses or to adhere to a particular trading program in spite of trading losses are material points which can also adversely affect actual trading results. There are numerous other factors related to the markets in general or to the implementation of any specific trading program which cannot be fully accounted for in the preparation of hypothetical performance results and all which can adversely affect trading results.