Forum Discussion

Iron Contributor

Jul 17, 2019

Help to find impact of variables on share price

Hi, I am looking to create a template which will be able to review the correlation or impact on factors upon a return of a share. I am looking at returns, and also the fundamentals of a company. ...

BI & Data Analysis

Charting

excel

Formulas and Functions

Macros and VBA

power bi

Kodipady

Iron Contributor

Jul 18, 2019

calof1 ,

If you are using Office365 version Micorsoft, has a template called "Investment tracker" , this may be a good place to start with. In excel File>New>Serach for online Templates will list the template.

You may not get all the variables you are looking for in this template. But if you know any website that provides fundamental data , Excel provides a way to refresh your worksheet with the web content. Please check Data->From Web option in Excel.

calof1
Iron Contributor
Jul 18, 2019
HiKodipady

Thanks for your message.

I have looked at the spreadsheet, however it appears to not find stocks based in Australia. Do you know if there is a way to change which exchange it view?

Many thanks,
- Kodipady
  Iron Contributor
  Jul 18, 2019
  calof1
  You can prefix the stock symbol with exchange code ( example XASX:TLS for Telstra or XASX:14D for 1414 degrees ).
  
  I was able to get few stock details with this method, but not for some. If this solution does not work for you, there are pointers on this link (specifically for Australian market) https://www.aussiestockforums.com/threads/live-feed-for-excel-spreadsheet.8671/
  - calof1
    Iron Contributor
    Jul 18, 2019
    HiKodipady
    
    Thanks for the reply.
    
    I will look at the website and review over the weekend.
    
    Thanks for your help.