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
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 )
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
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
To get 5 min Data
to get 15 min Data
to get 60 min Data
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)
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.
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????