I have uploaded here a source file. I contains data of 200 stocks column-wise, e.g. column A to L represent one stock, column N to Y represent second stock and so on.
For each stock there is a time column. Data generally starts from 09:15:00. But for some stocks data may start from 09:30:00.
If time starts from 09:30:00 for a specific stock, then entire data for that stock needs to be shifted downside. A macro needs to be developed such that it checks the start time of each stock and shift the entire data for stock by one row if time starts from 09:30:00. The result is demonstrated in result file.
The 200 stock data mentioned here is for illustration only and is the maximum amount of stock that can be present in a data array. There may be cases where less that 200 stocks may be present i.e. 150 or 162 or anything less than 200.
Hi, i have opened both the files and understood your requirement. THe macro can be developed and will work on static file. I suppose you download previous day or EoD info and work on it.
35 freelancere byder i gennemsnit ₹1065 på dette job
I am able to fulfill hard tasks within a short period. Has a good computer literacy and well versed with Office related softwares. Experienced in data entry for more than 2years.
I have good typing experience in ms office and I have worked as a Finance analyst, I am available to work any time with a comfortable budget have good experience in Accounting and Data Entry with Excel and words.
Data entry proficiency in SPSS, MS EXCEL, data entry and Microsoft office with 3 years of experience from the same field. Excellent proposal and grant writing skills.
Dear Concern i am full filled your project requirement. Kindly give me the chance to used my skills for your task more effectively & Efficiently.