Hi Team, Is there any way to get previous minute open high low close data into Excel.
For eg at 10:00 AM the values should be of 09:59 AM and at 10:01 AM all values should be updated to values of 10:00 AM.? Hope you understand my request..
You need to use Historical data for that. If you want to compute OHLC from live quotes, you need to write your own wrapper in VBA to store the data in text files or MS access database and calculate OHLC.
@HowUTrade Thanks for turnaround.. I dont want to store anything.. i just want to fire orders based on previous minute values. I built a system to fire orders when a particular scenario happens. for that i just need previous one min data in a row. i cant change the row every min. so i need values of OLHC for previous min in a row which should update every minute in the same row..
If you have any VBA code to achieve this, please do share.. Thanks in advance...
You need to use Historical data for that.
If you want to compute OHLC from live quotes, you need to write your own wrapper in VBA to store the data in text files or MS access database and calculate OHLC.
Thanks for turnaround.. I dont want to store anything.. i just want to fire orders based on previous minute values. I built a system to fire orders when a particular scenario happens. for that i just need previous one min data in a row. i cant change the row every min. so i need values of OLHC for previous min in a row which should update every minute in the same row..
If you have any VBA code to achieve this, please do share.. Thanks in advance...
Please refer the screenshot for better understanding of my requirement. Please guide me how to acheive this.
For Column G and J.. i will write actual formulas once i get desired numbers in other columns..