Showing posts with label Analytic Add-in. Show all posts
Showing posts with label Analytic Add-in. Show all posts

Thursday, July 25, 2013

Excel Geoflow Data Visualization


Geoflow for Excel 2013 allows us to visualize geographic and temporal data in Excel. It is very simple to use. I created an Excel example with the database of Wal-Mart; I only needed to define the latitude and longitude of each point, and defined what chart to show. Here is a video demo of how easy is to work with Geoflow.


The link of the Excel file is here.
Here is other link how to install Geoflow.If you found this helpful, please share.

Friday, July 19, 2013

Excel Power View: World Economic Outlook

Power View is a powerful add-in that allows us to visualize  the information included in PowerPivot. It includes a canvas page where we can create maps, add charts, upload images and setup tiles.  It has some characteristics similar to Tableau. In this posting I included an small example where I mapped the countries with the highest GDP growth in 2013 and added their respective flags, name and values. It is possible to choose other variables, and years. The world map was created automatically from Bing maps, and the flag images were uploaded from different URL addresses. This new concept of dynamic dashboards will definitively help Excel to compete with other database visualization software. 



The link of the Excel file is here. 
If you found this helpful, please share.

Thursday, July 18, 2013

Excel PowerPivot: World Economic Indicators

PowerPivot allows us to organize our information efficiently. We can import databases directly to PowerPivot and create relationships to better handle the information. These relationships help us to structure better pivot tables. For example, I linked three tables which contain data values, list of economic indicators, and country names from the IMF. I created a pivot table from these three different tables and used Excel sliders to extract the relevant variables that we want study. 


Excel file can be found here. Enjoy!

Saturday, February 16, 2013

Excel Model: Automatic WACC

How much time do you spend trying to calculate the WACC of a company? Well here is a simple method, and in less than 15 seconds. I used the excel add-in of the posting before (here is the link), and the formula of the hurdle rate to calculate automatically this ratio in excel. There some assumptions behind the calculations. Enjoy!


Download the Excel File







Wednesday, February 13, 2013

Excel Add-in: EXCEL Stock Market Functions

What happens when you can combine the information of yahoo finance and the power of excel? Well,  Randy Harmelink did it. He created an excel add-in that allows us to extract directly from yahoo finance and many others key financial information directly into our excel. I am currently working in a company valuation and getting the data took me a lot of time, now with this tool and its frameworks it is only a matter of seconds.  Enjoy!

Link to the add-in

Tuesday, February 12, 2013

Excel Add-in: XY Chart Labeler


It is one of the most useful add-ins in excel; it helps you to add labels to XY chart data points (scatter plot). Without this add-in we have to do it manually, which sometimes it is impossible. In the future, Excel should include this functionality but for the moment a good alternative option is to use this add-in. Find the link of the add-in below and an example.

If you found this helpful, please share.

Excel Example Scatter Plot
XY Chart Labeler

Sunday, February 10, 2013

Excel VBA: United States Business Cycle


One of the most popular techniques to identify the cycle of an economic time series is the filter of Baxter & King. This filter transforms the economic variable using a Fourier series methods. I created an Excel VBA program to replicate the results of this filter. With this macro we are going to be able to get the evolution of the cycle directly in excel without the necessity to use Rats or Eviews. The program is very similar to the method used in Rats. As an example, I used the US GDP to get what is the position in the cycle in 2015-Q5; it seems that until that date the GDP was still in a contractionary phase.



Excel Economic Database: Getting the Recession Indicators

Do you know that there are four indicators that help the NBER Business Cycle Dating Committee to determine if the US economy is in recession? Yes, these variables are Industrial Production, Real Income, Employment and Real Retail Sales. Each one helps to monitor how the US economy is doing as a whole.

I remember to get these variables some years ago you needed an analyst to keep the database updated or buy an expensive specialize services, but now the Federal Reserve Bank of Saint Louis allows you to track these figures easily; they created an excel add-in where you can extract time series, manipulate data and build graphs. Now if you want to know how is behaving an economic indicator you can use this very useful add-in.


If you found this helpful, please share.


Saturday, February 9, 2013

TreeMap: World Economy 2012

The excel add-in is a powerful tool that helps us to create more complex analysis in excel. There are many of them that we can get free in internet. One of the best that I found is Sparklines (link below). As an Example, I created a treemap using this add-in which shows how the participation in the world economy is changing between 2012 and 2000. China's and India's contributions are significantly better while the developed countries are falling behind. 

If you found this helpful, please share.

Download links:
Sparklines Excel
How to install an add-in
Download Excel file here