종료

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.

기술: Excel Macros, Excel VBA, 프로그래밍, Python

확대 보기: excel macro button, excel macro tutorial pdf, excel macros 101, excel macros tutorial, macros in excel for beginners, excel macro tutorial for beginners, excel macros examples, excel macros for dummies, excel macro cut values, excel macro paste cells right, extracting values website excel macro, excel macro cut paste values, vba excel macro column unique values, values internet excel macro, excel macro graphic values, excel macro paste values, excel macro retrieve values internet, automated analysis of raw data in ms excel, freelancer excel macro expert in mumbai, dealer excise billing software in excel

고용주 소개:
( 0건의 리뷰 ) Sydney, Australia

프로젝트 ID: #24515232

이 프로젝트의 입찰 현황은 다음과 같습니다. 입찰자: 28명, 평균 입찰가: $161

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 더 보기

$250 AUD (3일 이내)
(54 리뷰)
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 더 보기

$240 AUD (5일 이내)
(57 리뷰)
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 더 보기

$235 AUD (3일 이내)
(34 리뷰)
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 (3일 이내)
(24 리뷰)
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 더 보기

$150 AUD (5일 이내)
(20 리뷰)
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 (4일 이내)
(16 리뷰)
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 (3일 이내)
(22 리뷰)
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 더 보기

$250 AUD (7일 이내)
(17 리뷰)
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 더 보기

$95 AUD (3일 이내)
(3 리뷰)
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 더 보기

$250 AUD (3일 이내)
(8 리뷰)
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 더 보기

$166 AUD (1일 이내)
(2 리뷰)
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 더 보기

$300 AUD (7일 이내)
(4 리뷰)
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 (5일 이내)
(7 리뷰)
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 더 보기

$200 AUD (3일 이내)
(3 리뷰)
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 (3일 이내)
(1 리뷰)
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 더 보기

$111 AUD (2일 이내)
(0 리뷰)
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 더 보기

$140 AUD (7일 이내)
(0 리뷰)
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 더 보기

$140 AUD (7일 이내)
(0 리뷰)
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 더 보기

$180 AUD (5일 이내)
(0 리뷰)
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 더 보기

$75 AUD (7일 이내)
(0 리뷰)
0.0