Archive for March, 2008

Featured Spreadsheet: Intraday Calls Sheet

Wednesday, March 19th, 2008

SameerShaikh_Intraday_calls_Sheet
Intraday Calls Sheet
Sameer Shaikh
Indian stock market dashboard with dynamic changing bull bear strengths and dynamic sorting of stocks.
http://www.editgrid.com/user/engsameer/intraday_calls_sheet

Featured Spreadsheet: ADR

Tuesday, March 18th, 2008

adr.png
ADR
wargodriver
Predicting the opening of Hang Seng Index by tracking movements of ADR, it has 10,000+ daily unique visitors.
http://www.editgrid.com/user/wargodriver/adr

John Weight, Midas Investment Club

Friday, March 14th, 2008

We are a UK based investment club investing mainly in shares on the London stock market. A number of members had different ways of keeping track of our shares - mainly by using ‘portfolio’ facilities offered on a number of financial web sites. This was not ideal as individual members had to keep their own portfolios up to date - whilst others didn’t have the technical ability to do this.

As we had our own web site we had for some time been looking for a way of posting share prices to the site and enabling any member to get the latest picture without themselves having to do anything other than log on. I had been trying various on line spreadsheets but none were satisfactory until I discovered the ‘external data’ function in Editgrid. This allows on line prices to be shown in a spreadsheet with only the usual 15 minutes delay and continually updated. And the spreadsheet can be posted live to our web site. You can see this at www.midasinvestmentclub.org.uk - go to the Portfolio page.

In recent days I also discovered a new function which will post Reuters stock price charts in the spreadsheet. There is a template available for these, but thanks to Editgrid’s helpful and speedy response to my questions I have now discovered how to generate these from scratch. The charts are also posted to the website. Members can now get an up to date valuation and watch the trends in the charts by simply going to our site. I believe Editgrid to be the most useful of all the on line spreadsheets - and I think I must have tried them all!

Christopher Weddell, a Kiva.org lender

Friday, March 7th, 2008

Kiva.org allows you to connect with and loan money to unique small businesses in the developing world, empowering people to lift themselves out of poverty.

This revolutionary process is simple, engaging and fun, from beginning to end. So much so that many lenders have built up quite a portfolio of loans, which have become difficult to manage.

Using Editgrid lenders can use their Kiva.org data export (Excel spreadsheet) to its fullest. Data is manipulated, massaged and converted to provide some basic stats.

Using My Data Format various files are created for use, including:

  • A KML file of all loans
  • An iCal file of all active loans to show repayment dates
  • A homepage integrated with Exhibit 2.0 AJAX ‘magic’ to provide an interactive map, loan listing, and timeline
  • A banner to highlight a particular loan of interest
  • 2 Greasemonkey (FF) / Trixie (IE) scripts to highlight entrepreneurs and to provide country counts and highlights back on kiva.org

A number of members of kivafriends.org have started to trickle over and use a copy of this spreadsheet - with excellent reviews.

Well done Editgrid team, without you our kiva.org experience would be so much less.

Sameer Shaikh

Friday, March 7th, 2008

I was very much fascinated by MS Excel, right from my introduction to computers. I have developed several quality programs related to the stock trading in Excel but was always searching for the gateway to put it on the web and was never finding a way out.

One day accidentally i came across EditGrid, and it was last day i worked on Excel. I was feeling just like my dream has came true, i was highly intrigued by the EditGrid’s features. Further whenever i found some programming difficulties the competent EditGrid team has always helped me to find the way out.

Now my work is being used by thousand of my colleagues and thanks to the constant development of the EditGrid which will go on faciliating the problems i encounter. Really, EditGrid has changed the way the spreadsheets are used.

My best compliments to the team of EditGrid.