Gathering Financial Data in Excel With YCharts

Excel 2013, Excel function tutorials

If you want to learn Excel, keep reading or Get 10 days of free unlimited access to Lynda.com. for professional help and Excel 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


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

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

weight loss hcg side effects

weight loss hcg side effects…

Experiments in Finance…



crack do wsc real 2009 world snooker championship

crack do wsc real 2009 world snooker championship…

Experiments in Finance…



Anonymous

Especially if you are buying beads from online shops, make sure that the website produces quality beads.
(our last triangle player used one of my amps and blew out a cone.
Hyde Park is hosting a Winter Wonderland with an ice rink, observation wheel and Christmas Market.



fotki.com

fotki.com

Experiments in Finance



solange magnano

This is considered to be the main risk with rhinoplasty and it accounts for 5-15% of the cases that cause revision surgery as based on studies.
However it creates a subtle natural-looking result that doesn_t
appear too overdone. Some are dissatisfied with their natural
noses, some have incurred injuries to their noses, and some do not like how aging
has changed their noses.



celebrity diet

When you sign up for HCG wholesale, you are registering for ultimate
satisfaction. That list consists of a small apple, a small orange,
4-6 medium strawberries and a half grapefruit.

Dieters are recommended to drink as much water as possible, as
the adequate water consumption can help dieters feel more filling
and increase their body metabolism.



bandage dressing for burns

bandage dressing for burns

Experiments in Finance



Ed Mastery

Ed Mastery

Experiments in Finance



cajon drum and guitar city

cajon drum and guitar city

Experiments in Finance



frame Drum dvds

frame Drum dvds

Gathering Financial Data in Excel With YCharts | Experiments in Finance



independent.academia.edu

independent.academia.edu

Gathering Financial Data in Excel With YCharts | Experiments in Finance



used auto prices

used auto prices

Gathering Financial Data in Excel With YCharts | Experiments in Finance



dodatki ślubne

dodatki ślubne

Gathering Financial Data in Excel With YCharts | Experiments in Finance



maxi skirt

maxi skirt

Gathering Financial Data in Excel With YCharts | Experiments in Finance



Erik Goluboff

Erik Goluboff

Gathering Financial Data in Excel With YCharts | Experiments in Finance



Direct TV

Direct TV

Gathering Financial Data in Excel With YCharts | Experiments in Finance



cheap blackpool pleasure beach tickets deals

cheap blackpool pleasure beach tickets deals

Gathering Financial Data in Excel With YCharts | Experiments in Finance



trabajo

trabajo

Gathering Financial Data in Excel With YCharts | Experiments in Finance



Cara Daftar Sbobet

Cara Daftar Sbobet

Gathering Financial Data in Excel With YCharts | Experiments in Finance



www.voucherslug.co.uk

http://www.voucherslug.co.uk

Gathering Financial Data in Excel With YCharts | Experiments in Finance



website

website

Gathering Financial Data in Excel With YCharts | Experiments in Finance



lotto junkie

lotto junkie

Gathering Financial Data in Excel With YCharts | Experiments in Finance



auto parts

auto parts

Gathering Financial Data in Excel With YCharts | Experiments in Finance



blog da nuvem dourada

blog da nuvem dourada

Gathering Financial Data in Excel With YCharts | Experiments in Finance



Licensed John The Plumber In Kansas City

When installing a new two-piece toilet, install the bolwl
first and then the tank instead of attaching thee piecees
annd then installing it. Check that all warranties issued by the manufacturer, retailer and transporter are in place.
If the problem here is a tripped button, you can reset it by pressing it in. They work with electricians when problem related to electrical matters.
His path was a predeztined path sso to speak
and many of us fall into this category. Builders and contractors are otther people who routinely deal with plumbing services and they can givee yoou lot
of information about local plumbers, their quality of work and the rate
charged for their services. Teachers at Access Training plumbing classes in Bristol hae observed
that their female students arre often more careful and a lot less provable to leave clutter behind them after a job.
There is only onee wayy to find out, and that is to call a plumber.

The right Sydney plumbing company can help you keep your home in good working order.
Ask everyone in the family to take part in any such conferdences held to think up this list.



Clash Of Clans Hack Ios Dns

Clash Of Clans Hack Ios Dns

blog topic



pet urns

pet urns

Gathering Financial Data in Excel With YCharts | Experiments in Finance



Paket-C.com

Paket-C.com

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.