已完成

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

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.

技能: 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

授予:

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. Rega 更多

£20 GBP 在7天内
(0条评论)
0.0

13 威客就此工作平均出价 £16

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 Go 更多

£20GBP 在1天里
(49条评论)
5.4
akritisood94

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

£20GBP 在1天里
(88条评论)
5.5
legioner80ru

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

£20 GBP 在3天内
(1条评论)
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 value 更多

£10GBP 在1天里
(0条评论)
1.1
Srishti2326

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 更多

£11GBP 在1天里
(0条评论)
0.0
ritopalit

I am a cer

£19GBP 在1天里
(0条评论)
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 更多

£15 GBP 在3天内
(0条评论)
0.0
madhurisingh1943

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条评论)
0.0
FtnNabilah14

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条评论)
0.0
£19GBP 在1天里
(0条评论)
0.0
Khansadique161

I work genuinely and faithfully.

£19GBP 在1天里
(0条评论)
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 更多

£10 GBP 在2天内
(0条评论)
0.0