Hello Friends,
I am working on a new Finance/Stock related social networking website based on Drupal where I will be showing Company details of all companies being traded on NASDAQ and other exchanges.
I need to have a functionality for users to ask questions/offer advice on a particular stock and show all messages related to one stock in a list (kind of forum)
As their are lots of companies on each exchange and the number is not fixed and there will be new companies everymonth, I need advice on how to achieve this functionality.
Checkout http://ragingbull.quote.com/mboard/boards.cgi?board=AMZN as this is the type of Message board that I would like to have apart from other additional features that drupal can offer.
I am thinking on doing it in following ways:
1) Using Companies as Taxonomy for Forum
2) Creating a Content type for company and then creating another Content type Message and use Company content type as Node reference in that and use views to display messages for a particular company.
Please suggest which will be a good way to develop same. Also please do let me know if you think there is some other alternative to achieve same.
Thanks,
Tony

Comments
Your second idea, kind of
I'd suggest you go with something similar to your second idea.
Have companies as nodes. Make a node type so you can have things like ticker id and what not.
Then users will be able to comment, rate, track via RSS, etc companies.
Josh McCormack
Owner, InteractiveQA
Social Network Development & QA testing
http://www.interactiveqa.com
917.620.4902
aim: jmccormciti
skype: joshmccormack
Josh McCormack
Owner, InteractiveQA
Social Network Development & QA testing
http://www.interactiveqa.com
917.620.4902
AIM:
jmccormciti
Skype:
joshmccormack
Yahoo:
joshmccormack
Google Talk:
joshmccormack@gmail.com
Windows Live
Companies as nodes
Ultimately I think it depends on your specific strategy for the site but generally speaking I like the Companies as Nodes idea too - You'd have a lot more flexibility with it as a node compared to a taxonomy term. I would use taxonomy vocabs for industry groups and sectors which would allow you to categorize and group companies for even more potential forum topics.
Another consideration for you that I ran into before is changing ticker symbols. Something on my list of annoyances (yet to be created) is when I'm researching a stock that has gone through ticker symbol changes and I get fragmented threads (same company but threads based on different ticker symbols). As long as you base the thread on company id or ticker id (instead of ticker symbol) then it's not a problem. However I can see why it would be better to use ticker symbol in for example the URL aias for SEO.... in that case I'd just want to have a way to update the ticker, aliases, etc and keep the thread intact without making the world implode.
Thanks guys for your
Thanks guys for your comments.
I have started development using the 2nd option for now and will post my experience about same here.
Cheers.