Share Trading sheet google sheets

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


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.

Skills: Excel, Data Entry, Data Processing, Google Sheets

See more: how to create google sheet, google sheets stock analysis, google sheets link, google sheets 2018, stock trading excel spreadsheet, google sheets stock price, google finance update frequency, dividend stock portfolio tracker google sheets, share trading project design, private company share trading, upload price sheet google google shopping, net sheet excel sheets, show time sheet log sheets, online share trading requirements specification, share trading easy ravi bhokse, online share trading dhaka, spread sheet google foreclosure, retrieve longitude latitude excel sheet google, design online share trading project, excel application track share trading

About the Employer:
( 58 reviews ) UK, United Kingdom

Project ID: #25645627

Awarded to:


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. Rega More

£20 GBP in 7 days
(0 Reviews)

13 freelancers are bidding on average £16 for this job


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 Go More

£20 GBP in 1 day
(49 Reviews)

Hi I can try both on google sheet and on excel as [login to view URL] have a look over my reviews i am well experienced in excel.I will wait for your response ,we can discuss price and time over chat. Regards

£20 GBP in 1 day
(88 Reviews)

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

£20 GBP in 3 days
(1 Review)

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 value More

£10 GBP in 1 day
(0 Reviews)

Honestly, I possess all the skills and experience that you’re looking for. I’m pretty confident that I am the best candidate for this job role. It’s not just my background in the past projects, but also my people skill More

£11 GBP in 1 day
(0 Reviews)

I am a cer

£19 GBP in 1 day
(0 Reviews)

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 More

£15 GBP in 3 days
(0 Reviews)

hi there , im Madhur I have pretty much experience in data management on google doc . I will help you out from this problem. I read your description and saw png file im ready for this project

£10 GBP in 7 days
(0 Reviews)

hi and please stay safe at home. I am really interested in your job offer. I have attended a class for excel and word to improve my skills. I can type as fast as you wish. I've got a lot of time to fulfill and focus o More

£15 GBP in 7 days
(0 Reviews)
£19 GBP in 1 day
(0 Reviews)

I work genuinely and faithfully.

£19 GBP in 1 day
(0 Reviews)

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 More

£10 GBP in 2 days
(0 Reviews)