Skip to main content

Importing twitter feed in google spreadsheet

Often I wanted to store my twitter feed or any other online feed into my google spreadsheets. Here is how to do it.

USING GOOGLE DOCS SPREADSHEET
Create a new blank spreadsheet. In the column A2 enter  

=ImportFeed(“http://twitter.com/statuses/user_timeline/princemishra1.rss”,”items title”,false,20). 

Replace "princemishra1" with your twitter username. 20 is the maximum number of updates you can see at any one time. The updates are cached by the google server, so you may see some delays.
USING EXCEL
Create a blank spreadsheet. Select Data -> From Web
This should open the New Web Query Window. In the address field enter

http://twitter.com/statuses/user_timeline/princemishra1.rss (Replace princemishra1 with your twitter username) and press Go. Excel will now fetch all your twitter updates. After the fetching has finished click on Import.
Now, you should have an excel sheet with your twitter updates. To fetch new updates, select Data -> Refresh All

Comments

Popular posts from this blog

Capture and compare stdout in python unit tests

A recent fan of TDD, I set out to write tests for whatever comes my way. And there was one feature where the code would print messages to the console. Now - I had tests written for the API but I could not get my head around ways to capture these messages in my unittests.
After some searching and some stroke of genius, here's how I accomplished capturing stdout.


The economics of crypto investing

If you believe in the greater fool theory, there is no other market as speculative and volatile as the crypto market today. We are perhaps living in the biggest bubble of our times. I am not bullish on this market in particular. I am bullish on the mania. 90% of the cryptos we see today will crash. They are just tokens with no tangible value generation capability. However, I believe that the mania and euphoria will stay.

Having said that, should one consider investing in this market? Certainly!
The risk/reward is lovely, potential upsides and margins are huge and with 3-5% of your net worth, the bet on the mania is worth it.

How does one choose where to invest?

If you follow the stock markets, you are expected to do thorough Fundamental Analysis before investing. Expect the same for the crypto market. I invest in large caps. I invest in index funds. And I invest over and over again. Markets rise, always. Extrapolating the same strategy - invest in indices - the top 10 tokens by perfo…

Before you "judge" a python programmer

If you're coming from a compiled language context, using exceptions for flow control would look odd to you. But here's the thing - in the python world, exceptions are super cheap and using them for flow control is the "idiomatic python" way!
In fact, exception-driven flow control is built right into the language itself e.g. the "for" loop in python terminates when the iterable raise a "StopIteration" exception!

There is a lot of material on the internet already on the topic, so if there's one thing you take out of this post, it's this - in python, it's "Easier to Ask for Forgiveness than Permission"!