Suljettu

Create a custom excel spreadsheet

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. 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 A28, ie each sheet can include a maximum of 27 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 [url removed, login to view]

- 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

% 30 day - the % change in price from todays current price to the closing price 30 days ago

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)

XEC, S&P 500, 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: [url removed, login to view]: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

SOI - Shares on issue

MC (millions of dollars) - SP*SOI

Volume (ST) and Volume (MT) are cells that turn green if their formula is true; the formula for volume (ST) contains two variables, u and v, and the formula for volume (MT) contains two variables, w and x.

'u' and 'v', and 'w' and 'x', all equal cumulative trading volumes for different numbers of days. ie if u=3 then this returns the cumulative volume for the last 3 days of trading (including today if there is data available for today). 'v' is a user customisable number of days related to 'u', ie if v=6 then this cell returns the cumulative volume for the last 6 days of trading prior to the period 'u'. 'w' and 'x' are similar to 'u' and 'v' but just a different number of days (ie w=5, x=30)

An example of a formula for the volume (ST) column would be 'u'>2*'v'. If the formula is true then the cell turns green. The formula should be easily user customisable as should the day value of 'u', 'v', 'w' and 'x'.

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

Flag (column H) - This cell turns green if the value for column G 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 ([url removed, login to view])

Notes - A blank cell for me to input notes

Template sheets

These are blank templates that I can fill out if wanted. They must be coded in such a way that I can copy and paste these templates so I can have even more spreadsheets if needed

Please only bid for the project if you can complete all aspects of the project. Thanks

Taidot: Data Extraction, Excel, VB.NET, Visual Basic, Tietojen kaavinta verkosta

Näytä lisää: how to create a template in excel 2010, how do i make an excel spreadsheet a template, create excel spreadsheets, creating an excel template with formulas, excel custom text format, how to create a template in excel 2016, excel spreadsheet design service, how to create a template in excel 2013, create report excel spreadsheet, create simple excel spreadsheet template macros, create standalone excel spreadsheet, need custom excel spreadsheet, create app excel spreadsheet, create custom excel spreadsheet, custom excel spreadsheet creation, create letter excel spreadsheet, create form excel spreadsheet, create custom excel invoices import quickbooks pro, create custom excel file type, custom excel spreadsheet model jobs

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

Projektin tunnus: #16409058

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

$655 AUD 7 päivässä
(557 arvostelua)
8.2
schoudhary1553

Greeting, I have understood your Create a custom excel spreadsheet task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Extraction, E Lisää

$450 AUD 10 päivässä
(225 arvostelua)
7.3
mantislin

Dear sir, I am scraping expert. I have did more than 350+ scraping projects. Can we discuss more details about your project? then i can do example data or script for you, we can continue after you checked example Lisää

$392 AUD 6 päivässä
(234 arvostelua)
7.3
fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser Lisää

$263 AUD 10 päivässä
(61 arvostelua)
7.1
zekovicm

Hi there,I am Miljan,IT 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 agree Lisää

$444 AUD 3 päivässä
(49 arvostelua)
6.1
vlayausa

Hello, I like this project very much and I am proficient with Excel and VBA, so I would love to help you with making the requested macro. Please contact me for more information.

$370 AUD 10 päivässä
(129 arvostelua)
5.8
tiaratechies

Hello , we are a team of excel experts and have more than 15 years of working experience in excel, we are certified by Microsoft, if you are interested drop a message. We would like to work on this and give you the bes Lisää

$1000 AUD 3 päivässä
(36 arvostelua)
5.2
zu02

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current Ms Excel Lisää

$750 AUD 10 päivässä
(30 arvostelua)
5.7
usmanhassan123

A proposal has not yet been provided

$500 AUD 1 päivässä
(24 arvostelua)
5.1
carlosperezit

Hi I'm an expert in .Net technologies and SQL Server. I have been working in software development for the last 20 years I'm a specialist in web solutions and desktop applications I'm also available 24 x 7 Regard Lisää

$555 AUD 10 päivässä
(32 arvostelua)
5.1
lillysoft

Sir i am expert in software development. I have already developed many similar software . so i have deliver the system with best quality at cheapest price. I am waiting for you response Thank You

$444 AUD 2 päivässä
(22 arvostelua)
5.2
mingxiao2008

Dear,Sir I am very interested in your project and am ready for starting your project for now. I have experienced in developing Web Scraping and VB.NET and so on. I will work very hard and best for you. Best Regards

$555 AUD 10 päivässä
(6 arvostelua)
4.7
whitehorsetechn

Greeting, I have understood your Create a custom excel spreadsheet task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Extraction, E Lisää

$400 AUD 6 päivässä
(11 arvostelua)
4.8
Ahmed818

Hello, i am expert in this kind of jobs samples of my excel VBA jobs https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft Lisää

$250 AUD 2 päivässä
(32 arvostelua)
4.8
awaisjahangir25

Hi, Sir I’ve more than 5 years of experience of MS Excel and VBA programming. I understood your requirements I am confident that I can complete your project in all aspects. Kindly text me so we can start working on Lisää

$500 AUD 10 päivässä
(22 arvostelua)
4.6
vmadhavan15

Hi.. I am not a random bidder.. I have read all the instructions.. I hope I can do this one.. Please ping me if you are intersted with my proposal and thank you...

$500 AUD 10 päivässä
(11 arvostelua)
3.9
Carlosemadrizmor

i can do ot in Excel. MsAccess or Web page. I can give you excellent product. Super fast performance.

$300 AUD 5 päivässä
(3 arvostelua)
3.1
supergana

Hi - I am an excel whiz and have 2 decades of experience in dealing with excel. I am quite conversant with all aspects of excel. I have 2 patents in US. For the problem statement mentioned I have done a similar stuff Lisää

$493 AUD 7 päivässä
(4 arvostelua)
3.0
sloker18

I have read through your requirement to scrape commodity trading information from API, I am proficient with Excel and VBA, I assure your project will be delivered with high quality to meet all your requirements, awaiti Lisää

$250 AUD 10 päivässä
(3 arvostelua)
2.7
Bulasara

I am Pratibha Bulasara. I am a B-Tech graduate in Computer Science with 2 years of experience as a TIBCO Developer and supporter of TIBCO Admin at Tata Consultancy Services, L-Center, Bangalore in the project Deutsche Lisää

$277 AUD 10 päivässä
(1 arvostelu)
1.9