Formulas on webpages

  berni6670 21:46 17 Jul 2004

I want to put some finance calculator facilities on my website. The idea is that people can calculate compund interest, annuities, net present values etc whilst online

I havent a clue as to how to do this so if anyone can help I would be grateful. I cant do Java or HTML so I will need to copy the code from somewhere


  Forum Editor 10:25 18 Jul 2004

is via a script, but it's pretty complex, and I don't advise you to try unless you have considerable experience with scripting. There are many third-party solutions out there, and if you are serious about doing it I suggest you search for something suitable.

click here to see an example of the kind of thing I mean.

You'll need to run your site on a Unix server with PHP and a MySQL database installed.

  eldevllc 14:37 18 Jul 2004

Thank you for the reference. The site Gold-PHP is ours (Eldev LLC/ PHPStrike Tema). By the way, how you found it? Our new site is at click here We can make any custom programming, so no problems with designing financial calculators ;)

  berni6670 15:37 18 Jul 2004

I'm surprised there is no standard code for this sort of thing - isnt this a case of reinventing the wheel everytime. If not I'll have to ditch the idea - getting a someone to program things will cost too much for a little hobby website.

Does anyone know of a website that I could link to which provides online financial calculators?

Thanks again

  eldevllc 17:39 18 Jul 2004


  tbh72 15:12 30 Jul 2004

I might be able to help, would you be able to provide examples of what your after in Excel format?

  Simsy 10:42 16 Aug 2004

though it would exclude some folk from using it, is to write the formulae in Excel, then publish the Excel sheet as a web page with interactivity.

Unfortunately, though I'm sure this can be done, I'm not sure how to do it.

I think "end users" would need to have excel installed for it to work.

good luck,



  berni6670 01:33 17 Aug 2004

thanks for that suggestion

i'm not sure how to put an excel spreadsheet into a web page but i'll give it a go


  Simsy 14:11 17 Aug 2004

Save as "Web Page"

and make sure you tick the "add interactivity" box,



  Simsy 18:46 17 Aug 2004

Now I've got home, I've just tried this for myself... It works lovely when viewd locally, but not from my website.

I'm stumped I'm afraid.



  Taran 20:28 17 Aug 2004

Full Excel interactivity on the web is not a simple walk in the park.

Forum Editor detailed one way of doing this, by using PHP scripting with an underlying MySQL database on a UNIX server. The obvious alternative is ASP running off a Microsoft Access database on a Windows IIS server, but either one still requires database support from your host and someone capable of programming the necessary script(s) to do what you want.

The problem here is that there are so many possibilities, percentages, variables and whatnot you may well have to get something written for you from scratch.

There are ways of embedding Microsoft documents into web pages but this will still not offer full access to the full functions you write into the Excel spreadsheet.

Unless something is freely available that happens to meet your needs I think that this could be the time you source a web programmer. It all boils down to how much you want the functions on your site, whether they will add sufficient value to be worth having written and so on.

As suggested by eldevllc or a similar script site may have something suitable or that can be more easily adapted than having a program written from the ground up:

click here

click here

click here

click here

click here

click here

Good luck with it.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Print designer Kelly Anna on confident mark making & modern femininity

New iMac Pro release date, UK price & specs rumours

Comment créer, utiliser et supprimer son compte Facebook ?