Add-On Releases - Stock Trader for vBulletin

Stock Trader

Summary

This add-on gives your users the ability to use the money system on your board to "invest" in stock. Users can purchase and sell stock at market values. This plugin uses a stock feed from Yahoo to get real time stock quotes.

Release Notes

This product is considered to still be in Beta.This should be ending by the end of January.

This add-on is known to be compatible with vBulletin's built-in reputation system, vbBux and iCash.

Product Specifications

1. two plugins
2. one cron job
3. file uploads
4. one new DB table
5. one template
6. several phrases

Installation
Approx 2-5 mins

1. As always: Back up your Database!
2. upload the files in the "upload" directory, preserving the directory structure
3. Go into AdminCP and import the product-stocktrader.xml file.
4. (OPTIONAL) add a link in the navbar template or wherever your users can find it!

Upgrading/Updating

1. upload all files in the upload directory, overwriting any existing files
2. re-import the XML file, setting "Overwrite" to "Yes"

Configuration

1. vBulletin Options -> Stock Trader Options

Change History

• 0.9.9 (07-25-01) - fixed problem with trading mutual funds, fixed cheat with buying off hours (I think)
• 0.9.8 (07-18-01) - added new options and fixed bug with purchasing really cheap stock
• 0.9.7 (07-15-01) - fixed bug in top portfolios when using a table prefix
• 0.9.6 (07-15-01) - fixed table prefix issues, fixed portfolio.gif problem
• 0.9.5 (07-14-01) - added statistics page, ability to view other user portfolios, and postbit friendly variables
• 0.9.4 (07-09-01) - added a Capital Gains Tax option
• 0.9.3 (07-02-01) - fixed error with purchasing negative stock, fixed compatibility with iCash
• 0.9.2 (07-05-01) - bug fixes
• 0.9.1 (06-30-12) - added AJAX stock info lookup
• 0.9.0 (06-29-12) - initial Beta release

Future Features

• stock ticker marquee for users

Official Support

http://code.google.com/p/vbtrade/

PLEASE CLICK INSTALL!

[Lionel]

At what point does it insert those values ambportval, ambportgainamt , ambportgainper in table user? Mine are empty even though there are traders.

[Lionel]

Few bugs. I found the cron, but:

1-one portfolio value is 147,300.700, it displays 130,135.20 in top portfolios
2-In table user I have many values as -9999999.999 in both ambportval and ambportgainamt
3-If you sell all your stocks, the new portfolio value is not updated and it still displays in top portfoloios.

I am not sure I understand the WHERE clause in the cron

$symbols = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "stocktrader WHERE 1 GROUP BY symbol");

[zethon]

Originally Posted by Lionel

Few bugs. I found the cron, but:

1-one portfolio value is 147,300.700, it displays 130,135.20 in top portfolios

I will look into this if someone else reports a problem. My test board and my main board, the figures are consistent, as they should be when the market is closed.

Originally Posted by Lionel

2-In table user I have many values as -9999999.999 in both ambportval and ambportgainamt

Same as above. The default value for the field is 0.

Originally Posted by Lionel

3-If you sell all your stocks, the new portfolio value is not updated and it still displays in top portfoloios.

This is how it's suppose to work. THe cron job updates "Top Portfolio's" everyday. So, you won't see any changes immediatly show up in the "Top Portfolios" page.

Originally Posted by Lionel

I am not sure I understand the WHERE clause in the cron

Are you talking about the "WHERE 1"? What's there to understand?

[zethon]

Originally Posted by Lionel

At what point does it insert those values ambportval, ambportgainamt , ambportgainper in table user? Mine are empty even though there are traders.

They are updated by the cron, which by default runs every night at midnight.

[Lionel]

some screenshots

1.-top portfolio
2.-value of same portfolio
3.-strange value in database

[Quantnet]

Originally Posted by zethon

By request, I have added a statistics page to this add-on,the ability to view other user's portfolios, and variables which can be added into the postbit. Upgrade as normal.

How do you access the stat page ? How about postbit instruction ? Are these available yet?

[d8tabyte]

Hmm I uploaded all files, re-imported product and checked options.. when I go to top investors I get a 404.

Ive since upgraded to 3.6.4 and the standard mod works fine... any ideas?

http://digitalet.net/forum/vbtrade.php&do=topportfolios

[zethon]

Originally Posted by d8tabyte

Hmm I uploaded all files, re-imported product and checked options.. when I go to top investors I get a 404.

Ive since upgraded to 3.6.4 and the standard mod works fine... any ideas?

http://digitalet.net/forum/vbtrade.php&do=topportfolios

Yes, this was a bad on my part. The proper link should be: vbtrade.php?do=topportfolios

[zethon]

Originally Posted by Quantnet.org

How do you access the stat page ? How about postbit instruction ? Are these available yet?

I like to leave that up to the individual user. You can put the "postbit friendly variables" in postbit wherever you want. Same with the link to the stat page.

[Quantnet]

Can you give me instructions on how to display top 10 earners in Cyb - Advanced forum Stat mod ? Similar like top 10 posters....

I had Uncached templates: forumdisplay_sortarrow
when trying to reach vbtrade.php?do=topportfolios