Share Trading sheet google sheets

£10-20 GBP

Terminado

Publicado

hace casi 4 años

£10-20 GBP

Pagado a la entrega

Hi there I need help on Google sheets / Google finance or Excel I have already created a basic share trading sheet on google sheets. I want it to help me work out how much you would make depending on a pence or percentage price rise against a given amount of money invsted. The sheet is already created but isnt very user friendly and doesnt have all the functions. I would like a freelancer to help me add some functionality and redesign it. What i need - 1. If i enter a monetary or % price rise for a certain share I would like the sheet to show me (if possible with a pop up window) how much after fees I would make for a number of given amounts invested in that certain share Example: I expect the FTSE : CNA share price to rise 2p. So i want to select this share from the list and see only the data below for that share. If i invest 1,000, 2000, 3000, 4000, 5000, 6000, 7, 8, 9 ,10000 how much would i make after fees have been deducted ? i would like to sell all the totals 2. I would like the sheet to highlight which shares are trading very close to their 52 week low 3. I would like the sheet to display a 3 month average of the share price 4. Some of the columns are not displaying the numbers correctly - need some formating If this cannot be done on google sheets - then i would consider excel. But i want the sheet to use LIVE Share prices. I am open to ideas of a better way to do this.

ID del proyecto: 25645627

Información sobre el proyecto

10 propuestas

Proyecto remoto

Activo hace 4 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@SebasFerre

Good night, I am not familiar with Google sheets, but if you want real time price data and you have the last version of excel, you can obtain the same data, and the organization of the data would be much better. Regarding the pop-up window, I have an idea of how it could be done in excel with a VBA code. If you want to assign me the project, happy to do try help you tomorrow morning. Let me know if you are interested. To see what i mean, I have created this little sample, in which you can for example add the amount from the bottom that you required for the cell to highlight): [login to view URL] It is an excel file. Happy to talk to you, kindest regards.

£20 GBP en 7 días

5,0

(1 comentario)

0,8

10 freelancers están ofertando un promedio de £17 GBP por este trabajo

@finecodervw

Hi, Is it possible to get access to the sheet. Keen to work on this project. I have recently completed few Google sheets projects with good feedback Let me introduce myself as an expert in Google spreadsheets and Google docs. I am well versed with scripting in Google spreadsheets using Apps script, writing custom functions in Google spreadsheets, creating charts, custom functions, linking spreadsheets etc. I would be happy to answer any queries that you may have. Looking forward to working with you. Based on the sheet and further discussions we can agree on price and timeline. Thanks

£20 GBP en 1 día

4,9

(133 comentarios)

6,5

@legioner80ru

Hello, thank you for your interest in my profile. I'm ready to implement the project. best regards, Dima

£20 GBP en 3 días

5,0

(1 comentario)

0,2

@moinmk548

Dear client, I have read the project description.I am very much interested to do this job. I have 5 years of experience in Data Entry, Data collection , Data mining & Web Research.I respect client's time and values. I have very good typing speed also. I can do the job very easily. So plz give me the opportunity to do the job.

£10 GBP en 1 día

0,0

(0 comentarios)

1,3

@ritopalit

I am a cer

£19 GBP en 1 día

0,0

(0 comentarios)

0,0

@bhardushubham9

Dear Hiring Manager, I have gone through your job requirement and I understand that it requires a high speed typing skills with 100% Accuracy. I have 2.5+ years of experience working with MS Excel and MS Office tools.I have been doing Admin work like Typing materials from one source to other from long time. I am having excellent typing speed with 100% accuracy. I understand how critical the project is. I would like to be a part of this with all my experience in admin work. Please let me know, when can we discuss further on this project to have better understanding of the requirements. Thanks and regards, Shubham Bhardwaj

£15 GBP en 3 días

0,0

(0 comentarios)

0,0

@Khansadique161

I work genuinely and faithfully.

£19 GBP en 1 día

0,0

(0 comentarios)

0,0

@marufa20

Hello there, I read your project description and i am able to do this job. I can do your job as your demand. I will give you unlimited revision before and after the job. I am a new person in this website but honestly I have work experience more than 08 year's in other's online market sir. I am fully prepared to work with you. I have a lot of experience and skills in this job in other online markets. With me you get 100% satisfied in your work. You don't hire me for your satisfaction, just discuss with me once you project, see the demo I gave you and then let me know your decision. Thank you.

£10 GBP en 2 días