Find Jobs
Hire Freelancers

Help me complete an on-line learning course with a fun Excel project - Macros, Dashboard, a little VBA.

$30-250 USD

Mbyllur
Postuar almost 5 years ago

$30-250 USD

Paguhet në dorëzim
I am looking for assistance with an excel project that is part of an on-line course I am taking just for fun and my own personal learning. I already have a rough structure of what my vision looks like for this project but need help 1) Suggesting ideas to accomplish the objectives and 2) Putting in some of the legwork to construct the spreadsheet as I suddenly have very limited time for this. We will work collaboratively. Please see the requirements for the course project below: Project Overview Wallstreet Investments Ltd. is a stockbroker specializing in investments for wealthy private clients. Clients expect regular reports on how their portfolio of investments is performing. You are required to develop a flexible spreadsheet to assist in the real-time tracking of the value of a portfolio of shares held by clients of Wallstreet Investments. Project Requirements Upon opening an account with your firm clients provide an initial payment of at least $100,000 which will be split between cash and the recommended portfolio of shares. Your spreadsheet should contain a list of shares held by the client, the number purchased and the original purchase price. As an environmentally focused investment firm – Wallstreet Investments splits investments in the portfolio into Green and non-Green stocks (e.g. petro chemical vs. windfarm) and ensures clients that at least 40% of their portfolio will be invested in Green stock at any one time. Stocks when chosen for addition to the portfolio are deemed “Green” or “non-Green” by the user. Multiple shares may be purchased in a given stock at different times and for different prices. The current valuation of all the shares owned in that particular company should be represented by the spreadsheet. Current valuations should be sourced from a suitable website (MSN, Bloomberg, NASDAQ etc.) It should be easy for users of the spreadsheet to indicate that a stock has been purchased and the purchase price. Similarly, it should be easy to sell all or part of a portfolio at the current market price. The spreadsheet should track transactions and the current portfolio and its valuation. The spreadsheet should present a dashboard summarizing the portfolio of shares that the client has invested in. It should show the performance of the portfolio against standard market indices (FTSE 100 and the NASDAQ for example) for the period in which the fund was invested. The dashboard should show the proportion of Green and non-Green assets in the portfolio. It should be possible to view this summary in a browser window and e-mail the summary to the client. Upon completion this project will demonstrate most of the skills I learned in the course, including: 1. Constructing macros the operate from on screen “buttons”, 2. Simple dashboards that can be created with the “Charts” function. 3. Query the web for daily updated prices on stocks and market indices and use those prices when buying, selling, and reporting on the stocks. 4. Emailing a hyperlink to a client and making it viewable in a web browser. I know this project seems a little complicated, but results can be very flexible, and it really just needs to work and incorporate various functionality. It should be fun. I will decide on a freelancer to work with me based on 1. Price (flat fee or hourly with a cap on hours committed), and 2. Skill level of the freelancer - demonstrated to me via an explanation of how you would approach this project and execute on the functionality. Examples of past projects that might relate to this would also be helpful if available. Questions? Feel free to contact me!
ID e Projektit: 19276032

Rreth projektit

8 propozime
Projekt në distancë
Aktive 5 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
8 freelancers are bidding on average $368 USD for this job
Avatari i Përdoruesit
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$350 USD në 4 ditë
4,9 (336 përshtypje)
7,9
7,9
Avatari i Përdoruesit
I have seen the project - Help me complete an on-line learning course with a fun Excel project - Macros, Dashboard, a little VBA.. I have been working in these fields((Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps)) for 7 yrs as a freelancer. I will never disappoint you and i will try my best to deliver good result always. Hope to work with you. Thank you.
$150 USD në 3 ditë
4,9 (89 përshtypje)
6,6
6,6
Avatari i Përdoruesit
Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, PYTHON, WEKA, TABLEAU and EXCEL tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash
$500 USD në 3 ditë
4,8 (74 përshtypje)
6,7
6,7
Avatari i Përdoruesit
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.
$400 USD në 6 ditë
5,0 (102 përshtypje)
6,1
6,1
Avatari i Përdoruesit
Flexible spreadsheet to assist in the real-time tracking of the value of shares held by clients. I have many experiences in ACCESS, Excel VBA developing and data mining. I'm software engineer and algorithm expert. Your project is logic and algorithmic. Especially I'm very interested in that projects. I need $1000 and 30days for your project. 5 milestones ,i need. Your project is complex, but you and I , I'm sure we can complete your project successfully. Regard your good .
$100 USD në 3 ditë
4,9 (7 përshtypje)
3,7
3,7
Avatari i Përdoruesit
Hi, I am an excel enthusiast myself and I find your project exciting, challenging, doable and fun, I've been working with it for a long time generating a wide range of studies and reports... I have several ideas to pitch so if you'd like to discuss them let me know
$111 USD në 2 ditë
4,9 (13 përshtypje)
3,4
3,4

Rreth klientit

Flamuri i UNITED STATES
Oakland, United States
0,0
0
Mënyra e pagesës u verifikua
Anëtar që nga shk 17, 2008

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.