| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to extract one data from a website
I tried to web query but it only give me a whole table of data while I only
need the latest data only. The data one I want to get from this page is the "Last Trade" http://quotes.ino.com/chart/?s=NYBOT_DX Any suggestion? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to extract one data from a website
On another sheet, IF? the data is ALWAYS at cell b12, use =sheet1!b12
For a series use a looping macro to cycle thru or you can get all at once. If you send an email to my address below I will send you a file that uses Yahoo data. -- Don Guillett Microsoft MVP Excel SalesAid Software "Lamb Chop" wrote in message ... I tried to web query but it only give me a whole table of data while I only need the latest data only. The data one I want to get from this page is the "Last Trade" http://quotes.ino.com/chart/?s=NYBOT_DX Any suggestion? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import data from website everyday at certain time... | Excel Discussion (Misc queries) | |||
| Import data from a website to excel | Excel Worksheet Functions | |||
| Copying HTML Data From Website problem | Excel Discussion (Misc queries) | |||
| Copying Data forma website | Excel Discussion (Misc queries) | |||
| Copying data form website | Excel Discussion (Misc queries) | |||
![Lamb Chop[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
