Gathering Financial Data in Excel With YCharts

Excel 2013, Excel function tutorials

One of the most requested subjects on this blog is getting financial information into Excel. The easiest way of course is having a Bloomberg terminal which makes it possible to access a seemingly unlimited amount of data about the economy, publicly listed companies, indexes, etc. The possibilities are incredible. Think there is a drawback? Of course. Given it has a financial professional target audience, the cost is typically between $1000-3000/month depending on the type of service you have, if you’re getting live prices, etc. Yes you read that right, it’s per month.

It seemed incredible to me that no one was trying to disrupt this market no matter how complex it is. I have written a few times about how it’s possible to get some financial data from Google finance in Google docs, cloud-based spreadsheets:

Using Google Spreadsheets As An Alternative To Excel For Stock Prices And Information
Managing A Stock Or ETF Portfolio From Google Docs
How To Add Exchange Rates In Google Docs

There’s no doubt that those capabilities are very interesting and make it easy to track the value of a portfolio for example. What if you’re trying to do more though?

One clear candidate emerges: YCharts

Ycharts is a website where you can do a lot of what you’d do on a site like Yahoo finance or Google finance. You can build stock lists, look into a company’s financials, past statements, etc. The big difference is that if you join one of their paid memberships, you can get access to their very powerful excel plug-in. While not exactly Bloomberg, the possibilities with this spreadsheet are very very impressive. Look at how I’m using it personally:

I have a list of 300-400 stocks that are on my screener and represent potential purchases. I then have all of those stocks in a spreadsheet and look to get specific metrics such as market cap, price, dividend yield, P/E and some growth metrics with their custom formulas. For example, to get Blackrock’s dividend yield, I’d enter:

=YCP(“BLK”,”dividend_yield”)

Every time I refresh my spreadsheet, I’ll get updated values. This is what this specific spreadsheet looks like:

They also provide templates that you can use to either look at many companies or at one in more details:

http://ycharts.com/excel/templates

I’m guessing at this point i’ts starting to look like I was paid to write about this but I’m just a big fan of what they’re doing and have been a paying member for 6 months now.

Has anyone else given YCharts a try? If so, I’d love to get your thoughts.

***************************************************

Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss


***************************************************

52 Feedbacks on "Gathering Financial Data in Excel With YCharts"

visit the up coming website

visit the up coming website

Gathering Financial Data in Excel With YCharts | Experiments in Finance



online shops in nigeria website

online shops in nigeria website

Gathering Financial Data in Excel With YCharts | Experiments in Finance



Comments

Please Leave a Comment!





Please note: Comments may be moderated. It may take a while for them to show on the page.