Käynnissä

Build an excel spreadsheet which pulls information from the internet

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

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, Rahoitus, Visual Basic

Näytä lisää: build excel spreadsheet with forms, build excel spreadsheet, excel spreadsheet missing information, excel, excel macro copy information internet explorer, can copy website address information excel spreadsheet, contact information excel spreadsheet, macro excel display information internet, combine information single excel spreadsheet, copy information excel spreadsheet, macro pulls information internet, enter contact information excel spreadsheet, can paste internet information excel spreadsheet, job requires entering information excel spreadsheet, post information excel spreadsheet, can build front end excel spreadsheet

Tietoa työnantajasta:
( 1 arvostelu ) Mt Pleasant, Australia

Projektin tunnus: #16028895

Myönnetty käyttäjälle:

Sercho56

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 detail Lisää

$166 AUD 7 päivässä
(7 Arvostelua)
3.4

24 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

jaylancer43

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). Lisää

$300 AUD 4 päivässä
(602 arvostelua)
8.3
regphak

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 päivässä
(6 arvostelua)
2.6
maximwang8661

i just went through your job post. it's very interesting to me. If you hire me, I can start working for you right now.

$222 AUD 10 päivässä
(6 arvostelua)
1.4
marenchuk

hello i read your proposal and understand all you need. give me the task. if you hire me i will finish your task in time thanks

$100 AUD 10 päivässä
(5 arvostelua)
1.1
avidusman

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 Lisää

$300 AUD 1 päivässä
(12 arvostelua)
1.0
cgullapalli

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. -Ch Lisää

$250 AUD 2 päivässä
(761 arvostelua)
0.6
Nouran98

A proposal has not yet been provided

$277 AUD 10 päivässä
(0 arvostelua)
0.0
binish6

A proposal has not yet been provided

$222 AUD 10 päivässä
(0 arvostelua)
0.0
VBABharath

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 päivässä
(1 arvostelu)
0.0
SalmanCa

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 päivässä
(0 arvostelua)
0.0
logaprasath84

A proposal has not yet been provided

$222 AUD 10 päivässä
(0 arvostelua)
0.0
schoudhary1553

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 h Lisää

$300 AUD 6 päivässä
(279 arvostelua)
0.0
$150 AUD 3 päivässä
(0 arvostelua)
0.0
mtdevil369

Please contact me to discuss your project before hiring me. I am willing to help you if I know more details about your concern. Thank you.

$111 AUD 3 päivässä
(41 arvostelua)
0.0
binishimran

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 päivässä
(0 arvostelua)
0.0
$222 AUD 10 päivässä
(1 arvostelu)
0.0
zekovicm

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 Lisää

$222 AUD 3 päivässä
(92 arvostelua)
0.0
erninadia

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 Lisää

$177 AUD 8 päivässä
(0 arvostelua)
0.0
khadijakhan0305

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 g Lisää

$122 AUD 1 päivässä
(1 arvostelu)
0.0
enalgaban

Will fulfill the task as requested. Relevant Skills and Experience Expert in data entry

$222 AUD 10 päivässä
(0 arvostelua)
0.0