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 Excel VB.NET Visual Basic Web Scraping

หมายเลขโปรเจค: #16409058

เกี่ยวกับโปรเจกต์

30 ข้อเสนอ โปรเจกต์ระยะไกล ใช้งาน %project.latestActivity_relativeTime|แทนที่%

freelancer 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