Realtime Screen for stocks

[basudeo]

Hi Onkar,

Kudos! It is a great job. I joines this form somedays ago and was very curious to get some utility for getting free streamline quotes. I find your job just ultimate.

Will you please guide me for my some specific needs:

(1) Can I make a work book with this containing certain sheets with different stocks.

(2) How to make a separate sheet for NSE Futures. If you give me the source of codes of such stocks.

(3) How to make a separate sheet for options. If possible give the source for code of options.

(4) Yesterday high ,low are blank. I want to add previous close also to this.

(5) Excel has wide scope for charts so I want to add a column for charts.

Please guide me through forum or personally at my email:
[email protected]

basudeo

 

[sai20_2000]

Hi ONkar

The utility I found here is the best of the rest.
This eats much less of the resources and is consistent.

May I suggest

a stop button along with the start u have added
adding scrps beyond R20 donot reap bid and ask
and
time setting adjustments like during sun outages it will not fetch beyond 3: 31

 

[howisit]

Yes . It's really nice.
Make it available to all.
At least you can send it to my e-mail.
[email protected]

I made this thing for my own.

Features:

1) Free
2) Live, if you log in to Yahoo (with "Keep me signed in" selected)
3) Some times 10 to 20 seconds delayed
4) Refreshes automatically in every 5 seconds.
5) Automatically stops after market hours.
6) Colour coding for Up Down quotes, new High or Low made.
7) Excel based.

I will have to make small changes to allow anybody to use it for his own scrips.

Should I do this? Anybody interested?




I think, it looks beautiful.

 

[lvgandhi]

Dear Omkar,
There are twoaspects of time.
one is for display
Another for starting and stopping of fetching of data. As I am in USA on vacation, if the operation is linked to my system clock, I will never get the data during actual trading hours. Hence if getting data is delinked from system time, and in addition to start , a stop button will help.
Further adding more symbols than what you have given in row 21 may not be possible. My suggestion is to put it in a separate column be yond this table.
If you can share formulas of cells, we will be more thankful.

 

[newinvestor123]

HELLO SIR,

I AM INTRESTED FOR THIS.
PLZ SEND ME THIS.
[email protected]


Features:

1) Free
2) Live, if you log in to Yahoo (with "Keep me signed in" selected)
3) Some times 10 to 20 seconds delayed
4) Refreshes automatically in every 5 seconds.
5) Automatically stops after market hours.
6) Colour coding for Up Down quotes, new High or Low made.
7) Excel based.

I will have to make small changes to allow anybody to use it for his own scrips.

Should I do this? Anybody interested?




I think, it looks beautiful. [/QUOTE]

 

[sai20_2000]

Hello Omkar,

The file has stopped refreshing at 5 sec interval.What may have gone wronge.
Even I have reinstalled the MS office , but to no avail.

PLease advise

Regards

 

[omkarmango]

sai20_2000

PM me your email ID.
I'll try n send you new file as soon as I get some free time to make new one with old scrap stored in my computer.

Because I forgot completely the password for macros etc.
I have to make it again.


Omkar

 

[rohit.patidar]

just post the tool. or send to my mail [email protected]

 

[sanx]

@ omkar , can you please mention how to remove and add new stocks into the list ?

 

[basudeo]

hi Omkar,

Your screen was great. I was using it for the last three months. But from the last week it stopped refreshing. I downloaded it again but of no use.

My email is

[email protected]

please send me the screen.

thank you.

basudeo