Lengkap

Excel VBA for DATA IMPORT FROM .TXR FILES to excel file

There will be six .txt files in a specified folder namely :

NIFTY, BANKNIFTY, CNX-IT, CNXFMCG, NIFTYAUTO, CNXENERGY

Each file contains 1 minute intraday historical data for one month.

Task of VBA ------

There should be option to enter a specific date in the format YYYYMMDD.

When a specific is entered the vba should extract data of same day from 9.16 to 3.30 and data of previous day from 2.01 to 3.30 and finally feed the data in output excel file/sheet. One by one data from all six files of folder needs to be extracted in the same manner.

The format of output excel sheet is uploaded.

Suppose I have entered date : 20201202, then output data should be as per the format in uploaded sample output file.

Kemahiran: Excel, Excel VBA

Tentang Klien:
( 16 ulasan ) JUNAGARH, India

ID Projek: #33779188

Dianugerahkan kepada:

Yorkflying

Hi, I will be able to finish this work in 1 day. I specialize in Excel and VBA/Macro in Excel, Word, and Outlook with 20 years' experience. I will perform any tasks in MS office to automate your business. Excel, VBA m Lagi

₹600 INR dalam sehari
(5 Ulasan)
3.4

26 pekerja bebas membida secara purata ₹1496 untuk pekerjaan ini

(182 Ulasan)
7.0
(108 Ulasan)
6.3
merinsinha

Excel VBA Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this pl Lagi

₹2550 INR dalam sehari
(135 Ulasan)
5.6
(73 Ulasan)
5.0
MamukaB

Hi I can do this job within few hours or within day and can start work now. It's easy job for me, as I'm doing like this jobs my regular work I have 15+ year experience of Excel, Excel VBA and Have 100% feedback So, yo Lagi

₹1500 INR dalam sehari
(26 Ulasan)
4.6
abatsis

Hello, I am a PhD Industrial Engineer and have experience in data science,and can work on projects in the following fields: Data Modeling, Data Analysis, Flow Chars, ERD Diagrams, Data Entry, IoT, Industrial IoT, Power Lagi

₹1500 INR dalam 4 hari
(15 Ulasan)
4.3
vnegi2016

Hi, My name is Vikram, gone through your requirement extract and update information from text files. I can help you to create a VBA Automation as per conditions and requirements. I am having expertise and experienc Lagi

₹2000 INR dalam 5 hari
(15 Ulasan)
2.3
tabsamcgo

hello, this is my first time doing this freelance kind of job if you will give me a chance to try this i will make sure to do my job perfectly right

₹800 INR dalam 7 hari
(0 Ulasan)
0.0
aditigarg20024

Hi,I would love to work on your project.I read through the job details carefully and I am absolutely sure that I can do the project very well I can achieve the results that you are asking for on time. If you award me t Lagi

₹1050 INR dalam 7 hari
(0 Ulasan)
0.0
bsbindus5

Highly accurate data entry professional with 12 years of experience, seeking freelance projects. Detail-Oriented data entry professional with 10-Key Typing Speed of 15,000 KPH with zero errors. Maintained 99% accuracy Lagi

₹1000 INR dalam 7 hari
(0 Ulasan)
0.0
Gsdsheetal

Hello I am New Here but I have over 5+ experience in Data Entry and Research plus Content Writing. I am sincere and Hardworking. Please give me a chance to work with you. Best Regards Sheetal

₹1050 INR dalam 7 hari
(0 Ulasan)
0.0
vaibhav5959

I'm an accountant having 4 years of work experience in accounting, data entry operating, excel, word, English typing speed 30,40. I will do complete your work as soon as possible and carefully.

₹3000 INR dalam 40 hari
(0 Ulasan)
0.0
profmberia

I am confident that I am a good fit for this position for several reasons, but most specifically because of my dedication to going above and beyond in a job. I am committed to learning any new skills on my own to succe Lagi

₹1050 INR dalam 7 hari
(0 Ulasan)
0.0
muhammadsaim1419

Hello there, I've read your description and can build the expense management and profit for you. you'll be to manage your business expenses and earing easily using that. can you let me know a bit more about the pro Lagi

₹1100 INR dalam 7 hari
(0 Ulasan)
0.0
meghwalchatrara9

I am a data entry operator and I have experience to do this job. I also have experience of working excel, ws word, pdf etc. for last 2 years. And I hope that you will understand my responsibility.

₹1050 INR dalam 6 hari
(0 Ulasan)
0.0
nishathakur61012

I am student i know to do tele calling or excel entry or data entry i am hardworker or smartworker..

₹1050 INR dalam 7 hari
(0 Ulasan)
0.0
rtkgameinggamin4

killed in planning and organizing with the ability to complete tasks on deadline. An independent worker who successfully meets the challenges of a fast-paced environment providing data entry and administrative support Lagi

₹600 INR dalam 7 hari
(0 Ulasan)
0.0
saimshk63

I do this work with honest I do this job like I thought it's not your I think it's own my work so I can do this job with great devotion.

₹1050 INR dalam 7 hari
(0 Ulasan)
0.0
Shivraj358

Excel Hi, My name is Shivraj, gone through your requirement extract and update information from text files. I can help you to create a VBA Automation as per conditions and requirements. Please message me to discuss Lagi

₹1050 INR dalam 3 hari
(0 Ulasan)
0.0
msalman1262

I have best knowledge and experience regarding these types of work. I will follow rules and regulation accordingly during the job and I will trying to my best as per me.

₹1050 INR dalam 4 hari
(0 Ulasan)
0.0