I am a fulltime private Investor. I have a good excel list where I can research financial data on a monthly base. I have to go a step ahead now and upgrade it to an excel sheet where I can have daily data and still be able to easily copy and multiply the formulas. Of all that data a stock graph should be created (geometric averages of 10-30 years) which should not be a problem.
So far I pull free data/csv from Yahoo Finance "monthly" instead of "daily". When I have months I have 12 months and it is clear and easy but once I start to put days I will have to handle dates/trading days and combine with months and place/copy formulas in there somehow. I want to stay in the Excel domain (avoid VBA for excel if possible, Python etc. - all that (programming) I want to do at a later stage) so that I can understand and follow the process. So I need somebody who has extensive experience with Excel (and maybe Yahoo Finance, downloading stock data) and will figure out how to handle dates. For example: putting 18-23 trading days per month automatically into a frame with 25 rows or have formulas where Excel handles the days and combines it with weeks and months automatically.
Also it is important that I don´t loose too much time with communication problems. You should talk German or English and be used to communicate via messenger.
36 freelancers are bidding on average €18/hour for this job
Hello, I am highly interested. I am still here to start this project right now..!! If you are looking for data entry or search work, I am the Right person for you. available 24-7. A trusted Freelancer
I am an expert financial analyst with an experience in stock market for seven years. I have advance level expertise in Ms Excel and other Microsoft office applications. For more details, feel free to contact me.