Selesai

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.

Keahlian: Excel, Entri Data, Pemrosesan Data, Google Sheets

Lihat lebih lanjut: 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

Tentang Pemberi kerja:
( 58 ulasan ) UK, United Kingdom

ID Proyek: #25645627

Diberikan kepada:

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 Lebih banyak

£20 GBP dalam 7 hari
(0 Ulasan)
0.0

13 freelancer menawar dengan rata-rata £16 untuk pekerjaan ini

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 Lebih banyak

£20 GBP dalam 1 hari
(49 Ulasan)
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

£20 GBP dalam 1 hari
(88 Ulasan)
5.5
legioner80ru

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

£20 GBP dalam 3 hari
(1 Ulasan)
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 Lebih banyak

£10 GBP dalam 1 hari
(0 Ulasan)
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 Lebih banyak

£11 GBP dalam 1 hari
(0 Ulasan)
0.0
ritopalit

I am a cer

£19 GBP dalam 1 hari
(0 Ulasan)
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 Lebih banyak

£15 GBP dalam 3 hari
(0 Ulasan)
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 dalam 7 hari
(0 Ulasan)
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 Lebih banyak

£15 GBP dalam 7 hari
(0 Ulasan)
0.0
£19 GBP dalam 1 hari
(0 Ulasan)
0.0
Khansadique161

I work genuinely and faithfully.

£19 GBP dalam 1 hari
(0 Ulasan)
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 Lebih banyak

£10 GBP dalam 2 hari
(0 Ulasan)
0.0