Apologies to email subscribers: this morning’s first email did not include the video or chart (and it wasn’t a lame attempt at an April Fool’s prank!). This data was actually published last week but removed so it could run exclusively in The Globe and Mail on Friday. Now that it ran there, I can re-publish on this blog (part of my deal with them). Sorry for the multiple confusions!
I was just goofing around and put together this spreadsheet to play with Google’s motion charts. I took the annual returns from one of Libra Investment Management’s spreadsheets and created a “growth of $1” simulation for a bunch of asset classes as well as a diversified portfolio. I’m embedding two things: a YouTube video to explain how to use the chart, and the actual chart for you to play with.
FYI: The diversified portfolio in this version is 30% Canada, 15% US, 15% EAFE, 30% CDN Long Bonds, 10% Gold. I’ll make the full spreadsheet available another time in which you can change the asset mix of the diversified portfolio to anything you want and see the new visualization results.
First the explanation video:
Then the chart to play with yourself:
I have the pleasure to brief you on our Data Visualization software “Trend Compass”. TC is a new concept in viewing statistics & trends in an animated way by displaying in one chart 5 axis (X, Y, Time, Bubble size & Bubble color) instead of just the traditional X and Y axis. Discover trends hidden in spreadsheets. It could be used in analysis, research, presentation etc. In different business sectors, to name a few we have Deutsche Bank, NBC Universal, RIM, Vanguard Institutional Investor, Ipsos, Princeton University as our clients. Link on Drilling feature (Parent/Child) – Just double-click on any bubble:http://www.epicsyst.com/test/v2/drilling/ NBC presentation on TED using Trend Compass exported Videos on CNN Money/Fortune:http://tech.fortune.cnn.com/2010/12/21/from-laughing-to-judging-in-fifty-years-the-evolution-of-televised-emotion/ Link on our new Geographical Trend Compass (Earthquake in Japan – Mag vs Depth vs Time):http://www.epicsyst.com/test/v2/japan-earthquake Link on Ads Monitoring on TV Satellite Channels.http://www.epicsyst.com/test/v2/tv-monitor/ Link on UK Master Card vs Visa performance :http://www.epicsyst.com/test/v2/mastercard_vs_visa/ Links on Funds:http://www.epicsyst.com/test/v2/best_exchange_traded_funds/http://www.epicsyst.com/test/v2/us_insurance_funds/http://www.epicsyst.com/test/v2/aaim_fund_performance/ Link on other KPIs :http://www.epicsyst.com/test/v2/hospital_performance/ Link on Chile’s Earthquake (Feb 27th 2010):http://www.epicsyst.com/test/v2/EarthQuakeinChile/Link on weather data :http://www.epicsyst.com/test/v2/aims/ Bank link to compare Deposits, Withdrawals and numbers of Customers for different branches over time:http://www.epicsyst.com/test/v2/bank-trx/ Misc Examples :http://www.epicsyst.com/test/v2/airline/http://www.epicsyst.com/test/v2/stockmarket1/http://www.epicsyst.com/test/v2/football/http://www.epicsyst.com/test/v2/swinefludaily/http://www.epicsyst.com/test/v2/babyboomers/ Princeton University project on US unemployment :http://www.epicsyst.com/main3.swf A video presentation by Professor Alan Krueger Bendheim Professor of Economics and Public Affairs at Princeton University and currently Chief Economist at the US Treasury:http://epicsyst.com/trendcompass/princeton.aspx?home=1 You can download a trial version. It has a feature to export EXE,PPS,HTML and AVI files. The most impressive is the AVI since you can record Audio/Video for the charts you create. http://www.epicsyst.com/TrendCompass/FreeVersion/TrendCompassv1.2.2.zip Video on Trend Compass:http://www.youtube.com/watch?v=gzDCGB8xBq4&feature=related Since we already develop 3D Virtual Reality applications, please find below a link on a prototype for a new 3D VR Trend Compass application:http://www.youtube.com/watch?v=ueqULRUvikg&feature=related Regards. Amr SalahTrend Compass TeamEpic Systemswww.epicsyst.com
Cool,and that Libra web site is cool too
What is the breakdown of the balanced portfolio?