Excel modelling 2019 for ASX

Need to set up an import to get historical and current prices and data such as ASX listed

shares, commonly used market indicators such as commodity prices, interest rates, currency

values. Have this done on google finance, yahoo finance, Morningstar, Bloomberg. Open to

use of any that will retrieve the relevant data. Aiming to have this contained for all assets in

one spreadsheet.  I know google finance has the option: Seen at:

[login to view URL]

 Morningstar data also has an excel plug in which can be used:

[login to view URL]  Commodity prices an excel is:  [login to view URL]  [login to view URL]

Happy to use any, whichever is easiest

For example need the historical prices import for BHP from the asx. I wish to see what drives the

movement in share price. For example iron ore, petrol price movement etc. From this I aim to see how

much the price in a share is attributed to certain variables, market indicators. I also aim to be able to

use this to help forecast prices.

For example if iron ore drops 10%, it flows through to the expected change in share prices. This can

be done through, ANOVA, regression etc.

2. Once we have the historical data I would like to have a form of ANOVA, regression etc

analysis which will be able to show the impact of one variable such as currency or commodity

price has on the others, and how it will affect each variable or share. Would like to have a

form of report which shows this correlation or impact, also be able to have a set of scenario

which can be updated to test the impact on a portfolio of shares. For example petrol price

increases 10%, impact it will have on price of other variables and shares.

3. Would this is available I would like to use a monte carlo Simulation (or similar if suitable) to be

able to test the expected return for each share and the portfolio of stocks. I would like to find

the optimal share portfolio based on each scenario with the use of a macro enabling the

solver function. I have example attached which include the portfolio to show the highest

omega, sharpe ratio etc. I would a results tab (example on results tab) which shows the

sharpe ratio etc, and graphs the expected distribution curve of portfolio return.  I have Attached examples of spreadsheets which include samples of this, and have

seen many online. Any questions and ill find further resources to show what I am

aiming for an how to do it.

4. Open to any update on other tabs including formulas, information provided or other analysis

you seek fit. Aiming to have a dashboard which shows the information neatly and is easy for

the user to use.

Skills: Excel, Statistics, Data Processing, Data Entry, Statistical Analysis

See more: need report writer, need web based application, need project based algorithm, online excel modelling services india, freelancing excel modelling, need report written, simple excel type online database need, simple excel type online database need created asap, outsource excel modelling, need joomla based website completed website started already, need commission based sales people, crystal report based sql 2000 windows application, excel macro move rows need speed process, engine need text based mmog, jobs excel modelling, need home based chatters, bus line called worlds longest street bus line write program produces billing report based passenger trips cost tripscompany lar, compare excel sheets generate report based common fields, excel dash board project status report template

About the Employer:
( 0 reviews ) Bengaluru, India

Project ID: #21077002

7 freelancers are bidding on average ₹9484 for this job


I will be delivering the work within time with perfection at a negotiable price

₹4444 INR in 3 days
(0 Reviews)

I guive your work in 48 hour for 10000 INR. Relevant Skills and Experience I am a statistician And I have a big knowledge in development PHP, MYSQL etc. I also develop in VBA on Excel.

₹10000 INR in 2 days
(0 Reviews)
₹7777 INR in 15 days
(0 Reviews)

I have been working as a freelancer for last 2 years. I am well versed in MS Excel, Advanced Excel, PowerPoint, Power BI, Market research, Power BI.

₹13888 INR in 1 day
(0 Reviews)
₹7777 INR in 7 days
(0 Reviews)

I am skilled professional with above average skills in Excel. I am a master of VBA and have experience in Consolidating and Organizing Data. I have consolidation work by consolidating Worksheets from 32 different cou More

₹10000 INR in 7 days
(0 Reviews)

Hello, I've performed all the above test in the excel (not limited to this but have a knowledge of ARIMA/GARIMA and VaR in R) and have a thorough knowledge of the financial data that required to perform the regression More

₹12500 INR in 10 days
(0 Reviews)