We made a quick hack to find out the most demanded followers during the Twitter follow bug drama.
Seemingly Twitter had a small bug tonight. Here are the top “requests” for acceptance made by users : http://www.associated-parsers.com/accept/
May 11, 2010
Quick hack on Twitter Follow bug
August 9, 2008
A RSS feed for your country’s medal hunt in Olympics 2008
And how to create a feed for the medals won by your country’s Olympians from this Pipe? Here you go!!. This is the format of the feed url,
Replace XXX with the country code. Open your feed reader, subscribe to this URL and be the first to know when Olympians from your country win medals. Feed for my country is still empty. Dont miss the hot ones - China and United States.
Read the related entry in Pipe Feeds
I’ve created a Yahoo Pipe to find the list the medals won by a country in the ongoing Olympics 2008. Visit the pipe, enter the country code and click on “Run”. Find the list of Country codes here.
The results are displayed as shown in this picture,
And how to create a feed for the medals won by your country’s Olympians from this Pipe? Here you go!!. This is the format of the feed url,
http://pipes.yahoo.com/yemkay/olympics2008medalfeed?_render=rss&country=XXX
Replace XXX with the country code. Open your feed reader, subscribe to this URL and be the first to know when Olympians from your country win medals. Feed for my country is still empty. Dont miss the hot ones - China and United States.
Read the related entry in Pipe Feeds
August 9, 2008
Pipe Feeds - a website for showcasing my Yahoo Pipes
Pipe Feeds is the directory of my Yahoo Pipes. I will publish the Yahoo pipes created for my personal use on this website. Most of my pipes attempt to simplify the way you read your favorite content across the websites. My objective of creating Pipes is that, if you like a content from a particular section of a website, let the content come to you next time without you having to visit the website again. Widgetizing and embedding are some other benefits from Yahoo Pipes. This diagram depicts it more clearly.
To start with, I’ve published pipes for Cricket Quotes (from cricinfo), ThiruKural Widget and History of Tamil Cinema (from DinaThanthi).
The pipes Cartoons from Indian dailies, Cartoons from Tamil dailies and Adade Cartoons feed which were created in the past and later graduated to auto publishing sites are also listed.
The site is hosted on blogger. Each post will represent a pipe and has various links for embedding, gadget creation, feed subscription and Pipes source.
Read more about Yahoo Pipes and Pipe Feeds site
July 17, 2008
View cartoons from Indian magazines
In continuation to the Adade Cartoons site and feed, I’ve created two similar sites for aggregating cartoons from English and Tamil magazines.
The Toons of India site pulls cartoons from Times of India, Economic Times, Indian Express, Deccan Chronicle and Hindu, while the Tamil cartoons website aggregates cartoons from the popular Tamil magazines of Dinamani, Dinamalar and Dinathanthi.
View Toons of India
View Tamil cartoons
As explained here, these custom aggregators were created using Yahoo pipes, a free tool to generate custom feeds.
January 18, 2008
Chart added to Poorman’s Stock watchlist
Today is a testing day for naive investors in the Indian stock market. Index advanced and declined at 1:14 and it touched 700 negative in late trading. I wanted to make some quick bugs by investing in a loser and selling it when the market bounces back. So I shortlisted five such stocks using the BSE trends worksheet. As I also wanted to track few other stocks that are not in the index, I added all of them in my watch list.
But that didn’t help me tracking my favorite losers. Charts in Google Spreadsheets came handy at that moment and I created a new worksheet for the Gain-Loss chart which shows only the items in the watch list.
BSE and NSE entries are grouped in the chart. This is a published version of the chart which keeps on updating in every 5 minutes (Refresh the page to see the latest).
The chart may not be useful in the published version of the spreadsheet, but in the editable version, it’s interactive and shows a tool tip upon clicking the bar.
November 29, 2007
World Wide Spreadsheet - WWS
The title doesn’t mean that a spreadsheet can be world wide, but can be a powerful www contributor. Believe it or not, I’ve just constructed a stock watch list in a spreadsheet in 2 hours.
I’m a great fan of Microsoft Excel and have used it effectively for many of my projects. It allows you to manage large data effectively. You can do calculations, define formulas, conditional formatting, lookup in the sheet and even you can create interactive forms out of excel. It also has a nice feature, by which you can import XML data from web and map it to a range of cells. Data becomes dynamic in this case.
Well, if Google is coming to this market then there must be lot of unexplored opportunities in this field. It is actually, and having worked on a Google spreadsheet for sometime, I’ve realized its potential. It allows you to import XML, HTML and CSV data from external sources into the spreadsheet. There are functions like importHTML, importXML and importData that help you to do so. Interesting one is the importHTML function. Use this function to import a table from a web page and use the CONTINUE function to refer to a particular cell in the imported table. ImportHTML needs the URL and the index of the table in the HTML page. CONTINUE function takes the address of the cell, which has the importHTML command, the row number and the column number of the table cell to be referred.
For example, ImportHtml(“http://en.wikipedia.org/wiki/Demographics_of_India”, “table”,4) imports the demographic information for the population of India from a wiki page.
For more info on the above said functions visit this help page.
Here is a small example to illustrate the potential of Google Spreadsheets. This sheet imports data from ICICIDirect.com. I’ve created sheets for Indices, NSE & BSE exchanges and watchlist. First three are open to public as no input is needed for them. Watchlist, the last one is for my personal use where I can add quotes of my favorite stocks to track them.
View this spreadsheet in a new window.
If you never seen a Google spreadsheet I would strongly advice you to visit and have a glance of it.
Update: Added a worksheet named “GET STOCK CODE” for finding stock codes against company names.
RSS feed: http://blog.yemkay.com/rss
