Featured Spreadsheet: Intraday Calls Sheet
Wednesday, March 19th, 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!
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 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.
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.