Find Jobs
Hire Freelancers

Create a custom excel spreadsheet with possible integration into amibroker

$30-250 AUD

Ακυρώθηκε
Αναρτήθηκε περίπου 6 χρόνια πριν

$30-250 AUD

Πληρωμή κατά την παράδοση
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 - Just 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
Ταυτότητα εργασίας: 16321421

Σχετικά με την εργασία

3 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 6 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Σχετικά με τον πελάτη

Σημαία της AUSTRALIA
Mt Pleasant, Australia
5,0
1
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Οκτ 26, 2015

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.