Page 1 of 1

Investment and money management systems

Posted: Wed Jun 23, 2004 5:40 pm
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

Posted: Wed Jun 23, 2004 6:03 pm
by tim
you really should have a gander at the MySQL manual as alot of math functions can be generated by MySQL

Posted: Wed Jun 23, 2004 6:33 pm
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.

Posted: Wed Jun 23, 2004 6:36 pm
by Zooter
that's my problem... hmmm

Posted: Thu Jun 24, 2004 2:30 am
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.

Posted: Thu Jun 24, 2004 4:59 am
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