Zillow to google sheets. How to get data from Zillow to google sheets

Data from zillow.com can be referenced from Google sheets using some inbuilt functions that Google sheets provide. We will be using two functions for this.

  1. importxml()
  2. index

The importxml will import all elements which are matched in the xpath query. In the example below, we are asking google sheets to get the contents of elements with class value ‘zest-value’. Now this query alone will return two results. We need only the first one. That is why we use the index function and specify the “1” in the end. So the whole formula will look something like this.

=index(importxml(<insert the zillow link here>,“//*[@class=’zest-value’]”),1)

Here is an example.

=index(importxml(“http://www.zillow.com/homedetails/3817-Vista-Verde-Palm-Springs-CA-92262/63316638_zpid/”,“//*[@class=’zest-value’]”),1)

Youtube link showing copy of data from zillow to google sheets

Redfin to google sheets data copy

I tried to copy from Redfin to googlesheets using the same technique after making changes as per the sites source listing. But didn’t have much luck there. If you guys figure out how to do that, please share the same in the comments section.

6 Techniques in article writing you can learn from Thomas Friedman

We live in a world in which communication has so much impact in our daily life. The person who knows how to effectively communicate his ideas to invoke a particular reaction from his/her listener has a great edge. Recently, I came across a video in which Tom Friedman was interviewed by Salman Khan from the Khan Academy.

I always admired Tom Friedman ever since I read his book “The World Is Flat”. If you are looking for somebody who has the real world experience to tell you about how to convey an idea, then Tom Friedman is the guy.

Here is what Thomas Friedman thinks as in his words, “6 kinds of column”. I believe the same rules can be applied for any sort of written communication, be it a blog or an article. So what are the 6 kinds or columns? As per Friedman, If you get any one of these reactions from our reader, then you have a column.

1. I didn’t know that.

The first kind is the one which a reader reads your column and goes “I didn’t know that”. In other words, telling/reporting something that no body has told before.

2. I never looked at it that way.

If you present already known issue in a completely new perspective which has the potential to make the reader think, then that can be a successful column.

3. You said it exactly the way I felt. God bless you.

This kind of reporting strikes a chord with your reader. Most people do not have the gift of expressing their thoughts in the right words. The kind of “right words/expressions” which will preserve every little ounce of the way they felt about that situation/incident. Your readers will love you for it if you are able to pull that off.

4. I want to kill you dead, you and all your offspring.

You generally get this kind of reaction when you don’t jump on the “Popular ” band wagon and decide to go against it because you believe that it is right. It might not be what others want to read. But there are two benefits for this. Firstly, you can be content that you voice your true opinion and secondly, these kind of articles can earn you lot of (negative) publicity. But as some of you know, there is nothing called a negative publicity.

5. You made me laugh / You made me cry.

Very difficult to pull this one off. Very rarely people have the skill to consistently deliver an article and invoke the above reaction. When you do it well, it really works. When you miss it, like bad humor or bad sentimentality, you basically lose the reader.

6. You challenged me.

This is when a columnist/author challenges his own reader. In my personal opinion, if you are doing this correctly, it can be a great education for yourself and your reader.

Biz Stone quotes on success – Creativity is a renewable resource

Biz stone Quotes

Biz Stone Quotes

I am reading the book authored by the co-founder of Twitter, none other than Biz Stone. In my honest opinion, anyone who ever wish to be an entrepreneur should read this book. It is also highly recommended for those who wish to excel at their current jobs or those who are simply tiered of mediocrity. The book is called Things a Little Bird Told Me: Confessions of the Creative Mind

This guy is a college drop out who landed a job in Google and later left this job (which most of us consider a dream job) to create Twitter. So when he talks about success mantra, I think one should pay attention.  Let me quote a small excerpt from the above book.

Creativity is a renewable resource. Challenge yourself every day. Be as creative as you like, as often as you want, because you can never run out. Experience and curiosity drive us to make unexpected, offbeat connections. It is these nonlinear steps that often lead to the greatest work.

One of the things which I found interesting was a phase of his life when he used to design book covers. As per Biz stone,

Graphic design is an excellent preparation for any profession because it teaches you that for any one problem, there are infinite potential solutions. Too often we hesitate to stray away from our first idea, or from what we already know. But the solution isn’t necessarily what is in front of us, or what has worked in the past.

So, if you are looking for the next book that inspires you, then this is the book for you Things a Little Bird Told Me: Confessions of the Creative Mind

Only when the tide goes out do you discover who’s been swimming naked – Warren Buffett

Only when the tide goes out do you discover who’s been swimming naked – Warren Buffett

Anyone who witnessed the bubble bursts and the bull markets in the past 10-20 years will definitely understand what Buffett meant here.  Switch on the television or go to any stock analysis site and you will be immersed in “expert” opinions, stats, “hot tips” and more. Some people even go to the extent of predicting what will happen to stocks or even sectors in the near future and in the not so near future.

And then there are folks who do the stupidest thing. These people are so confident (or should I say their reality is so distorted) to lend money on high interest rates and invest them in stocks based on a hot tip. When the “stuff” hits the fan they will be left naked. They will lose everything.

Warren Buffett has only two rules in investing.

Rule #1.  Do not lose your money

Rule#2.  Follow Rule#1

I always knew I was going to be rich. I don’t think I ever doubted it for a minute. – Warren Buffett

I always knew I was going to be rich. I don’t think I ever doubted it for a minute.

– Warren Buffett

This quote is perhaps not on the top of the Warren Buffett quote list. I heard this when I was listening to one of his talks. The way he delivered this line is what impressed me. He was not even showing a hit of arrogance when he said that. He said it as if it was a fact. Since following great personalities is one of my main hobbies, I tend to wonder if I can find any commonalities among these exceptionally successful people .

Sure enough, you will find many. For one, I have observed that all these folks always “knew” that they would make it big. Knowing something is better than “believing” that something will happen. Both are far better than “hoping” that something will happen. The difference is that when you know something, you can visualize in your minds eye the clear path which will lead you to your destination. It is the quality of a man/women who lives a calculated and planned life. They will also have an unquenchable thirst to reach that destination. When you believe in something, you have that unquenchable thirst, but you don’t fully believe. Saying that you believe something is just an act of confirmation that you provide yourself. But when you know stuff, you eradicate the time wasted in self affirmation. “Hoping” without any action towards goal is the worst thing one can do. Some people think of themselves as planners. They will spend hours and days in planning stuff but never end up doing it. Taking the first solid committed step towards your goal can do wonders and the momentum will keep you going.

There is a famous quote “fake it till you make it”. If you pretend (Yes I said pretend) to be having a quality, you will find that with persistence, you will indeed adopt that quality. The fact that Warren Buffett subscribes to this idea is evident from his following quote about forming new healthy habits/qualities.

“You look at people who you admire and list out their good habits that you love to have. Strive to make those habits your own. “