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.
13 freelancers are bidding on average £16 for this job
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
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