# Excel Macro

Aim:

To determine the 3W and 3M trend for every day for the duration of the data.

Method:

Possible Calculation Function: This function will examine the data in the stock price tab and let the user know for which date to which data is possible to run the calculations for. To calculate the 3W and 3M for 1 day 253 data points (including the data point for that day) are required. For example to calculate the 3W and 3M for 22/03/2016 we will need data for up to and until 23/03/2015 (which is 253 data points). So the first step will be to display from which date to which data the calculation is possible.

Transferring the Data: For example to calculate the 3W and 3M for 20/03/2020 we will require the data from 21/03/2019. The program will copy all the data (Date, Open, High, Low & Close) from the stock market tab and paste it in the raw data tab. The calculations to determine 3W and 3M is done automatically we just need to pick the right values.

Picking the Right Values: In the 3W and 3M tab the software needs to look at the values in the length column and highest number will correspond to a price in the price column.

• If there are two values which are the same in the length column then the value with the most recent occurrence will be chosen hence the price.

• If there is are two values which are the same and have occurred in the same time period the value which corresponds to the lower price will be chosen.

Recording the results: After the value have been determined for a certain date the date and the 3w and 3m value will need to be recorded.

This process will repeat until all possible days are calculated and the results recorded.

Sample results for 5 days are given and more can be provided upon request.

Keahlian: Excel Macros, Excel VBA, Programming, Python

Tentang Pemberi kerja:
( 0 ulasan ) Sydney, Australia

ID Proyek: #24515232

## 28 freelancer menawar dengan rata-rata \$161 untuk pekerjaan ini

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Lebih banyak

\$250 AUD dalam 3 hari
(54 Ulasan)
7.2
schoudhary1553

Hello, I can help you with your project - Excel Macro I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects li Lebih banyak

\$240 AUD dalam 5 hari
(57 Ulasan)
6.3
zekovicm

Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed Lebih banyak

\$235 AUD dalam 3 hari
(34 Ulasan)
6.3
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

\$200 AUD dalam 3 hari
(24 Ulasan)
5.5
dvcontact

Hi, Would you like to see a quick demo of your Excel macro written to determine the 3W and 3M trend for every day for the duration of the data in your stock price data tab before you award the project? You can consider Lebih banyak

\$150 AUD dalam 5 hari
(20 Ulasan)
5.2
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing and looking forward to working with you. Thank you, Regards.

\$240 AUD dalam 4 hari
(16 Ulasan)
4.9
mtdevil369

I have understand the project requirement & interested to work for this project. I will start right now and I will do it before your time . Please send a message so we can discuss more & start the project. Thanks

\$100 AUD dalam 3 hari
(22 Ulasan)
4.5
suyashdhoot

Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp Lebih banyak

\$250 AUD dalam 7 hari
(17 Ulasan)
5.2
finecodervw

Hi, Keen to work on this project. I have gone through the video as well as Excel attachment. I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerP Lebih banyak

\$95 AUD dalam 3 hari
(3 Ulasan)
3.5
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 260 projects successfully completed here. I would like to help you create the VBA you need. Contac Lebih banyak

\$250 AUD dalam 3 hari
(8 Ulasan)
3.6
kirstarg

Hello! How are you? I can start break now! Excel reading is going well for me. We have a few works like this. You can see our profile or ask me for show you some links of our work, all from my company (NexoSmart). I Lebih banyak

\$166 AUD dalam 1 hari
(2 Ulasan)
3.7
SunnyXCJ

Hello. I'm Sim, a python expert. I saw your job and I'm sure what I can do your task perfectly. I already complete many python project and If you want, You can see my this days project. My all project provide best spe Lebih banyak

\$300 AUD dalam 7 hari
(4 Ulasan)
3.3
maguirrer

hello, I had more than 8 years working with VBA and can help You with your project, please send me a message with the file attached as example and I can start working on it immediately

\$166 AUD dalam 5 hari
(7 Ulasan)
3.0
satishtl

Hi, Went through the Excel and the Webm. - Trying to get the 3W and 3M prices datewise as in Record sheet. - Have good expertise in Excel macros and also knowledge in Stocks. - Have done candle stick analysis, price Lebih banyak

\$200 AUD dalam 3 hari
(3 Ulasan)
2.3
sivashamdz

I read your Aim and Method. Still I have few questions. I want to ask them now. kindly chat. thanks. siva.

\$55 AUD dalam 3 hari
(1 Ulasan)
1.2
Akib2020

Hi there, I'm javed my computer experience is 12 years more. I'm expert on microsoft advance excel, vba, macro, conditional formatting, consolidate multiple excel sheet, data conversation, data entry, pivot table, dash Lebih banyak

\$111 AUD dalam 2 hari
(0 Ulasan)
0.0
codingexpert009

Thanks for your posting      I already checked your project details and we have done same type for work before  I can provide you complete demo for your work FREE        I have 12  years of expert team in different Lebih banyak

\$140 AUD dalam 7 hari
(0 Ulasan)
0.0
shubhamsmk2008

Hello,sir I have good expertise over different Python Framework i.e. Django and Pyhton Library like Panda, Matplotlib, Numpy, Pyglet, Pygame…Etc. I also have good expertise over different AI Library. I have worked acro Lebih banyak

\$140 AUD dalam 7 hari
(0 Ulasan)
0.0
masterb325

- I have working experience of more than 5 years in this field. -Looking to bring the benefits of data analysis to your business, with my skill in R Programming Language, Python(Numpy and Pandas), Machine Learning, SQ Lebih banyak

\$180 AUD dalam 5 hari
(0 Ulasan)
0.0
sgo5884f49acdcb6

Hello Greetings I have good experience in Excel and macros. I have checked your project and I would like to work on this project. Your work will be completed within 2 days and the final sheet will be provided. No adv Lebih banyak

\$75 AUD dalam 7 hari
(0 Ulasan)
0.0