Create a custom excel spreadsheet

종료 등록 시간: 6년 전 착불
종료 착불

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 [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

% 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: [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

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 ([login to view URL])

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

Data Extraction 엑셀 VB.NET 비쥬얼 베이직 웹 스크랩핑

프로젝트 ID: #16409058

프로젝트 소개

30 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 5년 전

이 일자리에 대한 프리랜서 30 명의 평균 입찰가: $430

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). 기타

$655 AUD (7일 이내)
(706 리뷰)
8.4
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 기타

$450 AUD (10일 이내)
(325 리뷰)
7.9
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 기타

$392 AUD (6일 이내)
(296 리뷰)
7.6
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 기타

$444 AUD (3일 이내)
(137 리뷰)
7.4
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 기타

$1000 AUD (3일 이내)
(53 리뷰)
6.7
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 기타

$263 AUD (10일 이내)
(62 리뷰)
7.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일 이내)
(145 리뷰)
5.9
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일 이내)
(13 리뷰)
5.6
usmanhassan123

A proposal has not yet been provided

$500 AUD (1일 이내)
(65 리뷰)
6.1
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 기타

$250 AUD (10일 이내)
(81 리뷰)
5.8
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 기타

$750 AUD (10일 이내)
(32 리뷰)
5.8
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 기타

$400 AUD (6일 이내)
(13 리뷰)
5.2
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일 이내)
(30 리뷰)
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일 이내)
(22 리뷰)
5.2
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 기타

$555 AUD (10일 이내)
(34 리뷰)
5.1
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 기타

$500 AUD (10일 이내)
(35 리뷰)
5.3
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 기타

$493 AUD (7일 이내)
(26 리뷰)
4.8
Carlosemadrizmor

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

$300 AUD (5일 이내)
(4 리뷰)
3.6
rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself for this project. please contact with me. Thanks.

$300 AUD (1일 이내)
(11 리뷰)
3.5
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 기타

$277 AUD (10일 이내)
(1 리뷰)
1.9