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.

Навички: Excel, Введення даних, Обробка даних, Google Sheets

Деталі: 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

Про роботодавця:
( 58 відгуки(-ів) ) UK, United Kingdom

ID Проекту: #25645627



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 Більше

£20 GBP за 7 дні(-в)
(0 відгуків(-и))

13 фрілансерів(-и) у середньому готові виконати цю роботу за £16


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 Більше

£20 GBP за 1 день
(49 відгуків(и))

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 за 1 день
(88 відгуків(и))

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

£20 GBP за 3 дні(-в)
(1 відгук)

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 Більше

£10 GBP за 1 день
(0 відгуків(и))

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 Більше

£11 GBP за 1 день
(0 відгуків(и))

I am a cer

£19 GBP за 1 день
(0 відгуків(и))

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 Більше

£15 GBP за 3 дні(-в)
(0 відгуків(и))

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 за 7 дні(-в)
(0 відгуків(и))

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 Більше

£15 GBP за 7 дні(-в)
(0 відгуків(и))
£19 GBP за 1 день
(0 відгуків(и))

I work genuinely and faithfully.

£19 GBP за 1 день
(0 відгуків(и))

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 Більше

£10 GBP за 2 дні(-в)
(0 відгуків(и))