HOLLYWOOD STOCK EXCHANGE
THE ENTERTAINMENT MARKET
THE ENTERTAINMENT MARKET
I use five worksheets within the spreadsheet (details inside)
A worksheet listing the active Moviestocks and their prices, and a second one for the active Starbonds and their prices. If you ask HSX, they may send you a link to this data from an XML feed, which you'll have to edit (I do this in Word) before c&p'ing into the spreadsheet.
A third worksheet for the Starbonds section of your portfolio. Again, I edit this in Word to make it work in Excel.
A fourth worksheet that lists all the active Moviestocks and delisted Moviestocks that are in Starbond TAGs, as well as their prices/box office and release dates, Use the LOOKUP function to search the worksheet with the Moviestock XML data to show the current prices of active stocks as a proxy for expected BO. Box office of delisted stocks has to be typed in manually, as do release dates. I also specify whether a stock is wide or limited, and then use an IF formula to generate a delist date (based on the release date plus a number of days in release)
The fifth worksheet (and this is the big one) calculates the expected next adjust. Each Starbond gets a row, and there are columns for the five movies in its TAG (with release dates and box office displayed - use the LOOKUP function to bring this data across from the fourth worksheet) and also columns for any future movies the Starbond is attached to (with delist dates and HSX price - using the LOOKUP function again). Now you have all the info you need to generate the current TAG and an adjust forecast based on current HSX price.
Now bring the Starbond's current price from the Starbond XML sheet using the LOOKUP function to compare it with the Starbond's expected adjust. You can also bring how you are holding a Starbond by using LOOKUP, to verify that you are holding a Starbond in the 'right' direction and also how much profit/loss you have made on your investment.
Those are the basics, but over time I've added a few extra features - for example, I use formulas to generate the ROI and dROI of expected adjusts and highlight potential dead delists, conditional formatting to flag potential issues (like two movies delisting on the same date, or where movies are not listed in the proper date order).
It's a lot of work to put together - the best way is to develop the structure first, and then add starbonds as they approach adjust.
without doing a complete starbond review (ugh with 225 bonds)- how do you keep track of your bonds? Nov 29, 21:17
I currently am holding 636 bonds. It's nearly impossible to keep up with them. Nov 29, 21:40
I use a day planner, where I list all my bond info Nov 29, 23:35
I would like to see how you have that set up. Sounds like a good system. {nm} Dec 01, 00:18
I use five worksheets within the spreadsheet (details inside) Dec 01, 07:21
It's really simple Nov 30, 16:00
true enough Dec 01, 11:42
Oh for sure, it's all about how much you want to put in. I'd recommend most people use PG or one of the other bond sites Dec 01, 13:59
