Real Time Line Chart revisited.

[GuluGuluu]

Hi,

I am very new to this forum as well as Excel coding. I know only simple excel operations. So I came to real hurdle.
Hello all my Brothers/Sisters,

I am a stock-trader, and on searching to find solution to my problem, I came to this thread:

http://www.excelforum.com/excel-char...day-chart.html

There, 'Prabs' described a problem of creating a new continiously changing real-time chart from two excel cells, one is data (A5) another is time (B5). He wants to draw a real time chart during stock market trading hours. It seems 'Loz' has a good solution to the problem. He provided some good code.

Now my problem is, I am very much novice to excel and don't know how to use that code...where to paste...how to run etc. Tried a lot...but failed every time.

I am using Excel 2007 and attached is the screenshot of my excel sheet where you will see two securities trading NIFTY and BANKNIFTY. They are having LTP at column B and Time at column M which are updating from my trading terminal.

What I need is to draw a real-time price charts of these two securities....or more securities if I add later.

Anybody please help me.

May God Bless all of us,

Warm Regards,
Bulan
nf-bnf.jpg

[GuluGuluu]

Anybody please?

[GuluGuluu]

Dear all, how to solve the problem? Where to paste the code?

[GuluGuluu]

Nobody knows how to copy-paste a code that is already solved?