Investment and money management systems

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

Post Reply
Zooter
Forum Commoner
Posts: 45
Joined: Tue May 18, 2004 10:46 am
Location: South Africa

Investment and money management systems

Post by Zooter »

Hi,

I'm trying to design and build some of the code and db-related stuff for an investment / money management system, but being a regular progammer with little e-commerce or financial knowledge, I'm struggling a bit. I have a technical spec, but some of it is really greek to me...

Anyone got any expertise in this field. I'm struggling with terms like stop losses and break-even bids, and how to compute these values from the info I have in the db.

Thanks
User avatar
tim
DevNet Resident
Posts: 1165
Joined: Thu Feb 12, 2004 7:19 pm
Location: ohio

Post by tim »

you really should have a gander at the MySQL manual as alot of math functions can be generated by MySQL
McGruff
DevNet Master
Posts: 2893
Joined: Thu Jan 30, 2003 8:26 pm
Location: Glasgow, Scotland

Post by McGruff »

Sounds like a "domain specific knowledge" problem rather than a programming one. That's a big part of being able to produce useful software quite apart from programming skills. It's difficult to work out how best to satisfy a client's needs without a good understanding of the workings of their business.
Zooter
Forum Commoner
Posts: 45
Joined: Tue May 18, 2004 10:46 am
Location: South Africa

Post by Zooter »

that's my problem... hmmm
Illusionist
Forum Regular
Posts: 903
Joined: Mon Jan 12, 2004 9:32 pm

Post by Illusionist »

You might want to look over at hotscripts.com for some e-commerce scripts or whatever. You can get ideas fromt hose, or jsut sue those if you want.
Zooter
Forum Commoner
Posts: 45
Joined: Tue May 18, 2004 10:46 am
Location: South Africa

Post by Zooter »

One question here...

I have a table with an amounts field. If the value is positive, it indicates a "buy". If the value is negative, it indicates a "sell". There's also a date field (DATETIME), that gets a value everytime a buy or sell happens. I have to find the date now at the point where the amount of buys equals the amount of sells. Is there a way to do it with one or a few SQL queries (has do be atomic if more than one querie)? Or must I combine this with PHP?

thanks
Post Reply