Import Data into Excel

traderhardrock

Well-Known Member
#2
Didnt get what you meant by 'pull'
But if I get you right then a simple copy paste of the table into Excel will do the job.
 
#4
If you are using ODIN trading terminal,simply right click at market watch page,there is one option of open data in excel,I think it will serve your need.:rofl:
 

Blackhole

Well-Known Member
#7

amitrandive

Well-Known Member
#9

mastermind007

Well-Known Member
#10
Blackhole

Tried but not happening,
If possible can you show screenshot for data imported for the webpage of Moneycontrol I have shown?

http://www.moneycontrol.com/india/stockmarket/concurrent-losers/marketstatistics/nse/3days.html
When you access the website from a regular internet browser, it works fine but when you access it from the Excel, the website seems to springing an invisible JSON object that is then preventing Excel from accessing the underlying table ...

If you access to UNIX (LINUX) operating system on your network that you can use, it has lots of utilities such as lynx, curl, wget that may be able to bypass all this nonsense and get to the data.

Outline of Steps
1) Develop the script on linux box and save the file on shared drive that is common between windows and linux. Your Script will have to written such that it can repeatedly fetch the data and keep overwriting the text file.

2) Excel will than have to repeatedly read from the text file.

3) Synchronization is also the key; Excel must not attempt to read the file while script is writing and script must not write while Excel is reading.

Ports of those linux utilities do also exist for Windows but they do involve a learning curve
 

Similar threads