Hi guys:

I am trying to create a sheet to pull out data from a MAIN DATA sheet in a file into another sheet (CALCULATION) based on selection in an INPUT sheet....

For this I need help on creating date validation and an Action Button containing a macro.

I have explained what exactly I want to do in the attached file.... (AM UNABLE TO ATTACH THE FILE)

I will appreciate any help that may be given.....

I had put out another request yesterday, but have not recd any reply.... It is extremely urgent and will be very obliged if anyopne can help me.... I am pasting it again for your reference and perusal......

I have been using excel for a long time. But when it comes to programming and VBAs, I would say I am a novice. I am clear about what I want to do, but don't know how to go about it. Let me know if any of the walk-ins or anyone you know who can help me....



The below link gives the realtime backfill data...

http://www.google.com/finance/getpri...=1266701290218

where



q= stock symbol on Google finance
x= exchange symbol
i= interval (here 60 means 60 sec (1 minute interval))
p= no of period(here 5d denotes 5 days of data)
f= parameters (day, close, open, high and low)
df= difference (cpct is may be in % change )
auto =1,
ts = time start… if you cut the last 4 digits…the rest gives the start day in seconds

you can choose your own set of value depending upon your need.

The following link gives the 1 min Realtime data for Nifty

http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

Using the above explanation we can build any formats (1min, 5min, 15min, 60 min) of real time data and can be use as a backfill

To get 1 min Data
http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

To get 5 min Data
http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

to get 15 min Data
http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

to get 60 min Data
http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

Here is the link where the yahoo finance offers real time data updates in realtime in csv format at free of cost. (This sentence is the hyperlink to the site)



I am trying to create a sheet so that I have to key in the scrip name in cell A1 and the duration (1 min / 5 min / 15 min / 60 min) in cell B1.

I would need exactly 500 datapoints whether 1 min / 5 min / 15 min / 60 min.

Then using VBA (which I want someone to design and help me) I should be able to get the data in Excel format on realtime basis..... the above links give the data in CSV...

Finally the file should be designed in a way so that if I want real-time data for 50 - 100 stocks simultaneously, I should be able to get it.....

The most important aspect is getting the data in excel and have it updated on realtime basis….

Can this be managed????

Thanks & Regards,
Navin Agrawal
[email protected]