STOCK MARKET! I KKNOW HOW NOW!

[Erik Mortis]

I FIGURED IT U+OUT!.... I know how to make a stock market that can integrate with the bank...

Each stock is it's own entry... Mind you if there are THOUSANDS of stocks per company.. this makes for LOTS of entries.. but it makes the most sense to me how to track them.... And the database should be able to handle that many entries....

[Andreas the Wise]

You remember I still plan to program one in the near future?

[Ari Rahikkala]

Hello. This is a primer on using relational databases as more than just flat file stores.

Code: Select all

mysql> describe users;
+----------+------+------+-----+---------+-------+
| Field    | Type | Null | Key | Default | Extra |
+----------+------+------+-----+---------+-------+
| username | text | YES  |     | NULL    |       |
+----------+------+------+-----+---------+-------+
1 row in set (0.00 sec)

mysql> describe stocks;
+-----------+------+------+-----+---------+-------+
| Field     | Type | Null | Key | Default | Extra |
+-----------+------+------+-----+---------+-------+
| stockname | text | YES  |     | NULL    |       |
+-----------+------+------+-----+---------+-------+
1 row in set (0.01 sec)

mysql> describe userstocks;
+--------+---------+------+-----+---------+-------+
| Field  | Type    | Null | Key | Default | Extra |
+--------+---------+------+-----+---------+-------+
| user   | text    | YES  |     | NULL    |       |
| stock  | text    | YES  |     | NULL    |       |
| amount | int(11) | YES  |     | NULL    |       |
+--------+---------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> select * from users;
+----------+
| username |
+----------+
| ari      |
| erik     |
| scott    |
+----------+
3 rows in set (0.00 sec)

mysql> select * from stocks;
+-----------+
| stockname |
+-----------+
| vbnc      |
| megacorp  |
| jhi       |
+-----------+
3 rows in set (0.00 sec)

mysql> select * from userstocks;
+-------+----------+--------+
| user  | stock    | amount |
+-------+----------+--------+
| ari   | jhi      |    100 |
| ari   | vbnc     |      5 |
| scott | megacorp |  10000 |
+-------+----------+--------+
3 rows in set (0.00 sec)

mysql> select * from userstocks where user = 'ari';
+------+-------+--------+
| user | stock | amount |
+------+-------+--------+
| ari  | jhi   |    100 |
| ari  | vbnc  |      5 |
+------+-------+--------+
2 rows in set (0.00 sec)

mysql> select * from userstocks where stock = 'vbnc';
+------+-------+--------+
| user | stock | amount |
+------+-------+--------+
| ari  | vbnc  |      5 |
+------+-------+--------+
1 row in set (0.00 sec)

mysql> insert into userstocks values ('erik', 'vbnc', '10');
Query OK, 1 row affected (0.00 sec)

mysql> select sum(amount) from userstocks where stock = 'vbnc';
+-------------+
| sum(amount) |
+-------------+
|          15 |
+-------------+
1 row in set (0.00 sec)

This was a primer on using relational databases as more than just flat file stores. Hope you enjoyed it!

[Erik Mortis]

Why didn't I think of that?

Andreas... are you actually gonna do it any time soon?

[Jonas]

Why didn't I think of that?

Andreas... are you actually gonna do it any time soon?

Otherwise you can make one for me. Kildare will pay.

[Erik Mortis]

It will work for the entire commonwealth.

[Andreas the Wise]

You remember I still plan to program one in the near future?

I'm finished exams as of yesterday afternoon, so I have time to program. So yes. I've thought through all the added stuff about price adjustments and making it profitable etc - and yes, will design it for the whole commonwealth, and incorporated with the bank, now I know how easy that is.

Ari - I'm not entirely sure I understand what you're getting at ... but I'll look again when I've got a little more into programming it.

[Erik Mortis]

Oh.. well.. then I guess I ought toss what I got or send it to you. (not that I have much. Just the tables really). The bank can now handles mods better.

You might wanna figure out what Ari is getting at here. It makes a LOT more sense then what I had in mind. and might be the only way to do it well.

I was gonna create features in this order.

1. Ability to create stock for Company accounts.

2. Ability to set stocks a "Available" for sale. And to set the sale price.
ability to view all stocks set to "Available".
ability to buy stocks for the set price. moving the money as appropriate.
logs.

3. Dividends. (Not sure how to do this well)