Find Jobs
Hire Freelancers

Build an excel spreadsheet which pulls information from the internet

$100-300 AUD

Status
Publicerad nästan sex år sedan

$100-300 AUD

Betalning vid leverans
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
Project ID: 16028895

Om projektet

20 anbud
Distansprojekt
Senaste aktivitet sex år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
Tilldelad till:
Använd avatar
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 Om 7 dagar
5,0 (27 omdömen)
5,6
5,6
20 frilansar lägger i genomsnitt anbud på $223 AUD för detta uppdrag
Använd avatar
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 Om 4 dagar
5,0 (802 omdömen)
8,6
8,6
Använd avatar
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 Om 2 dagar
5,0 (976 omdömen)
8,1
8,1
Använd avatar
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 Om 6 dagar
4,9 (413 omdömen)
8,2
8,2
Använd avatar
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 Om 3 dagar
4,9 (165 omdömen)
7,6
7,6
Använd avatar
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 Om 8 dagar
5,0 (16 omdömen)
4,2
4,2
Använd avatar
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 Om 1 dag
4,9 (12 omdömen)
3,9
3,9
Använd avatar
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 Om 10 dagar
5,0 (1 omdöme)
3,1
3,1
Använd avatar
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 Om 1 dag
5,0 (5 omdömen)
1,3
1,3
Använd avatar
I'm an expert in MS Excel with more than 6years of working experience. I have also trained many people
$200 AUD Om 10 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Will fulfill the task as requested. Relevant Skills and Experience Expert in data entry
$222 AUD Om 10 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
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 Om 8 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
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 Om 10 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
A proposal has not yet been provided
$277 AUD Om 10 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
A proposal has not yet been provided
$222 AUD Om 10 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
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 Om 10 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
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 Om 10 dagar
4,0 (1 omdöme)
0,2
0,2
Använd avatar
A proposal has not yet been provided
$222 AUD Om 10 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I will work in a smart way
$222 AUD Om 20 dagar
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för AUSTRALIA
Mt Pleasant, Australia
5,0
1
Verifierad betalningsmetod
Medlem sedan okt. 26, 2015

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.