Find Jobs
Hire Freelancers

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
프로젝트 ID: 16028895

프로젝트 정보

20 제안서
원격근무 프로젝트
활동 중 6년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
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.
$166 AUD 7일에
5.0 (27 건의 리뷰)
5.6
5.6
20 이 프로젝트에 프리랜서들의 평균 입찰은 $223 AUD입니다.
사용자 아바타
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
$300 AUD 4일에
5.0 (802 건의 리뷰)
8.6
8.6
사용자 아바타
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
$250 AUD 2일에
5.0 (976 건의 리뷰)
8.1
8.1
사용자 아바타
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,
$300 AUD 6일에
4.9 (413 건의 리뷰)
8.2
8.2
사용자 아바타
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
$222 AUD 3일에
4.9 (165 건의 리뷰)
7.6
7.6
사용자 아바타
I'm ready to start this project as soon as possible. I love data entry project and I do it well. Don't bother around. I will do a great job.
$100 AUD 8일에
5.0 (16 건의 리뷰)
4.2
4.2
사용자 아바타
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.
$300 AUD 1일에
4.9 (12 건의 리뷰)
3.9
3.9
사용자 아바타
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
$222 AUD 10일에
5.0 (1 건의 리뷰)
3.1
3.1
사용자 아바타
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.
$122 AUD 1일에
5.0 (5 건의 리뷰)
1.3
1.3
사용자 아바타
I'm an expert in MS Excel with more than 6years of working experience. I have also trained many people
$200 AUD 10일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Will fulfill the task as requested. Relevant Skills and Experience Expert in data entry
$222 AUD 10일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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
$177 AUD 8일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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.
$333 AUD 10일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
A proposal has not yet been provided
$277 AUD 10일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
A proposal has not yet been provided
$222 AUD 10일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Can perform any work related to MS Exel spreadsheet, data entry, ad copy paste effectively in lesser time. By profession i am a chartered accountant.
$234 AUD 10일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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
$222 AUD 10일에
4.0 (1 건의 리뷰)
0.2
0.2
사용자 아바타
A proposal has not yet been provided
$222 AUD 10일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
I will work in a smart way
$222 AUD 20일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (AUSTRALIA)
Mt Pleasant, Australia
5.0
1
결제 수단 확인
10월 26, 2015부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.