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.
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.
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!
Home Market report Site map Open trades Latest trades
|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.