Sunday, October 25, 2009

CIS8020 Assignment 2 PC Gold Vs Crude prices API Tracker

Scenario:



An affluent client has asked for a comparison between Gold & Crude Oil prices from an Investment Management Firm.The Investment Management firm decides to provide static charts for average values for the latest three quarters and refrains from real time up-gradation as it uses third party data.



Solution:



Google spreadsheets & visualization API is a good method to execute the query and can be easily be incorporated into any website.The website has to collect input data (Crude Oil Prices & Gold prices) and display in the requisite format.The prototype is as follows:




The source data for this prototype can be viewed here:



http://spreadsheets.google.com/pub?key=tX572Gre0yQkL0LGzZZpehg&single=true&gid=0&output=html



Such an API saves time & cost of programming and is easy to maintain.This not only allows the website to customize data as per specific client needs but also allows the scope for real time up-gradation capabilities,if required.The entire model can easily be incorporated in the website and offers better service quality.



Disclaimer:Past Performance is not indicative of Future performance.The data is taken from third party websites and does not represent any research or ideas or advice from the publisher.

2 comments:

  1. This is nice article... so, i will agree this words... Most of the people purchases were gold bracelets and jewelries that will be used for marriages in the coming months. Gold bullion sales are not that stellar, however, due to the high price of gold, but jewelry is not affected.

    Thanks for the great reading, we buy gold buy in a recession. I will pass this on to our Ira clients to read.

    ReplyDelete
  2. Where did you find the API for the live gold price?

    ReplyDelete