Build an excel spreadsheet which pulls information from the internet
$100-300 AUD
진행 중
게시됨 약 6년 전
$100-300 AUD
제출할때 지불됩니다
Thanks for reading this project. What I'm looking for is for someone to do the coding behind the attached excel spreadsheet. Explanatory notes are as follows:
General notes
- All sheets- must automatically update on spreadsheet opening
- The stock names in column A in all sheets (aside from overview and commodities) must automatically be in alphabetical order. Ie even if I add a new stock name to anywhere in column A, column A and the associated rows should automatically rearrange to be in alphabetic order. It must also be flexible enough to allow me to delete a stock name in column A if no longer needed. Similarly, I should be able to add further stock names (up to and including A36, ie each sheet can include a maximum of 35 stocks)
- Stock share price, shares on issue and volume of shares traded can be sourced from anywhere you like. The source should be free and a long term source. I have the amibroker program installed so information regarding stock share price+volume of shares traded may be obtained through that. Other sources of information could include [login to view URL]
- The excel document should open quickly and not lag
Overview
% Now - the % change in price since open if currently trading, otherwise the % change in price for the last day of trading
% 60 day - the % change in price from todays current price to the closing price 60 days ago. Present the number to two decimal places. The number should be green if positive (ie if the price 60 days ago is less than the current price), red if negative
Value - the current price of the stock/benchmark
The top 2 rows should stay in their position with one chart underneath it per page (ie if you press page down you get to the next chart)
S&P 500, XEC, XSO, ASX 200 have both 1 year and 5 year charts - the 5 year one should come first then the 1 year one. Chart the different symbols in the same order they are listed on the spreadsheet. The symbol for the chart (ie XEC) should be above the chart, hyperlinked to the source website of the chart.
S&P 500 futures % info should come from the following page: [login to view URL]:30&density=X&pricesOn=1&asPctChange=0&logscale=1&im=30&sym=ESH18&grid=1&height=500&studyheight=100
Commodities
Same explanation as the "overview" sheet
Other sheets
SP - Current share price (given to 3 decimal places, if applicable), ie $0.044)
SOI - Shares on issue (in millions)
MC (millions of dollars) = SP*SOI
SP7 - = ((SP today)/(SP 7 days ago)-1)*100 (7 is the default, but it should be a user customisable number of days). Same idea with SP30 column but just a different number of days. If the result is positive, the font for the cell should be green. If the result is negative, the font for the cell should be red.
Flag (column G) - This cell turns green if the value for column F exceeds a user customisable number (default 15%)
Ann. - This cell should have a hyperlink in it that links to the ASX page for the company listed on that row that has their announcements for the last 6 months. An example would be for the company PLS ([login to view URL])
Graph - A toggle box or something similar should be placed in this cell. See the graph explanation on the right hand side of the sheet for further details
Notes - A blank cell for me to input notes
Template sheet
This is a blank template that I can fill out if wanted. It must be coded in such a way that I can copy and paste this sheet as many times as I want and fill them in with additional stocks
***Please only bid for the project if you can complete all aspects of the project.***
Thanks
I will write you the VBA code necessary to automate this data download. I have already written a similar workbook with VNA for myself that uses the ASX data to monitor my stock portfolio.
Happy to discuss finer details before you award.
Hello,
My name is Jay and I am Excel and Web Scrapping Expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story).
About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of.
I will not disappoint you, please give me an opportunity to work with you. No milestones required in advance, please pay me once the job is 100% complete.
Thanks,
Jay
Hi,
I am good at Excel and VBA. I can scrape the data and read the detailed description provided. Looking forward to discuss and work on the project.
I have worked on scraping stocks from various websites.
-Chandra
Hello,
I have the good knowledge of Build an excel spreadsheet which pulls information from the internet
. I have more than 5 years of experience in Data Entry, Data Processing, Excel, Finance, Visual Basic
. We have worked on several similar projects before!
We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion.
I can assure the 100% job satisfaction.
Thanks,
Hi there,I am Miljan,Web Scraping expert from Bosnia & Herzegovina,Europe.
I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline.
Check out my profile, portfolio, and former clients feedback - that'll let you know everything about me.
Please feel free to contact me so that we can discuss further details.
Thank you for taking the time to read my proposal.I am looking forward to hearing from you.
Kind regards
I am an expert in excel macro and vba coding and excel programming as well. My experience in the field is more than 11 years and have done many such projects that has brought quite valuable skills in me.
I have read some requirements you mentioned in the project and am fully confident that I can do all this very efficiently.
I have also got a team of professional workers so its not a big deal for me.
Lets please discuss to get this completed in a day.
Hi there,
My Name is Smile Mittal.
I have read your instructions carefully and I am ready to do work.
I am waiting for your positive reply.
Thanks & Regards,
Smile Mittal
I am an experienced Data Entry operator working in this field for about 5 years. I can do your given task within the time limit with 100 % accuracy and perfection.
Looking forward to work with you, Hire me today and get my services.
Hai ,
I have read your proposal and I understand what you require early, so I'm so glad to work for you for this job. For your information, I really love this job and I'm here to make your task easier.
Do contact me if there is anything you wanna ask. For sure I will response and I hope it would be yes.
Thank you for your attention.
Erni Nadia
I have the ability to do it in a timely manner
Relevant Skills and Experience
I am researcher and have done qualitative and quantitative research work.
having 6 years of experience in doing similar jobs for big corporate.
I hope, I have given the best bid among others.
have a good understanding over stock markets