News Focus
News Focus
Followers 5225
Posts 24469
Boards Moderated 5
Alias Born 09/20/2000

Re: Imperial Whazoo post# 58166

Monday, 09/29/2008 9:19:44 AM

Monday, September 29, 2008 9:19:44 AM

Post# of 99130
Imperial Whazoo, to answer your SPZI question...

First, sorry for my delayed response as I am a little slow at times.

With SPZI, to answer your question, I think in the very near future we will see something released from Bloomberg confirming that they have signed a multimillion dollar contract with SPZI. This is just my opinion from doing my due diligence (DD).

It was one of your posts that took my research and confidence in SPZI to another level where I would not have done otherwise. Thanks!

**********************************************************************************************************

This is the post of yours that meant a lot to me to push me to further research SPZI:

http://investorshub.advfn.com/boards/read_msg.aspx?message_id=31601344
Posted by: Imperial Whazoo Date: Wednesday, August 20, 2008 3:41:16 PM
In reply to: ~6979~ who wrote msg# 55926 Post # of 58485

You said, "People are scared of something new until they see someone else benefit from it. " Very insightful, ~6979~.

Well, ~6979~, if you lurk around here, then you know this, but I'll say it in case you are unaware: I use SpoozChartz.

Now, I'm gonna spend some of my valuable time and tell everybody some of what a little independent thought and actual elbow grease has generated.

What I'm doing is using some of SpoozChartz' features to perform real-time, two way connectivity between an Excel spreadsheet and SpoozChartz. And the complicated part of the solution is not SpoozChartz.... its a known program called Excel. Believe it or else, the hardest work is on the Microsoft side of things. As everyone around these environs should know, Excel is extremely widely used.

Now, the way CapnDon explains SpoozToolz (ask him youself.... I have emiled him at least 3 times today alone), it consists of series of worksheets tabs in an Excel spreadsheet workbook. The connectivity "pivot point" for both SpoozChartz (with which I am familiar) and SpoozToolz (which CapnDon saw up-close and personal.... and bear in mind he is a professional programmer), is Excel.

Now, SpoozChartz has three modules: 3D Optimization Charts, PowerLanguage, & QuoteManager. Today, it has the ability to connect directly to the following datafeeds/brokers. The following list is the list that is available when you right-click on Tools \ Data Sources from the menu bar of the QuoteManager in SpoozChartz:
AGN Futures
ASCII Mapping
Bloomberg
CyberTrader
Free Quotes
GlobalServer
IQFeed
Interactive Brokers
MarketCast
Metastock
Open E Cry
Patsystems
QFeed
Tenfore
Tradestation
Transact Futures
Universal DDE
eSignal
otFeed

Now, notice the one called "Universal DDE". Essentially, it allows connectivity to SpoozChartz via any DDE compliant data source. So, what this means is that I can connect to datafeeds that are not on that list if they are DDE compliant. I can connect to a realtime datafeed like MarketLink, which is an aggregator that aggreates the feeds from essentially the same mix of exchanges as does Bloomberg.

Now lets spend a few minutes contrasting a retail, internet delivered datafeed like Marketlink's and Bloomberg. Here's a rough overview of what I've learned about Bloomberg, which I don't use. I looked into it, just like I did about 50 other solutions, but Bloomberg is just too expensive, among other things, for "Everyman". Bear in mind, I do subscribe to eSignal, DTNIQ, & Marketlink, and I have working Excel spreadsheets that perform custom VBA "Black Box" calculations as we speak.

To get Bloomberg, you subscribe to a dedicated T-1 line rather than coming in over the internet (like eSignal, QFeed, IQfeed, & Metastock from the "approved" list of SpoozChartz datafeeds). Now I get 6 meg downside on my cable connection and 10 meg downside on my fiber DSL connection, but T-1 is a mere 1 meg down, so the datafeed itself is slower. You connect directly to the Bloomberg servers, so you are not bouncing around the world when you use Bloomberg, which is the case in internet delivery. So, the latency in Bloomberg is less, despite the slower speed. Also, the "smaller pipe" (the 1 meg bandwidth) was several hundred dollars last time I checked, even for a fractional T-1. And, because the Bloomberg datafeed employs a smaller pipe, it has to be custom compressed when sent and uncompressed on receipt. In its favor, Bloomberg is streaming and lower latency, while DDE is client/server & Barcharts-style RTD datafeeds are push/pull.

So, there is the higher cost for a dedicated T-1 needed by Bloomberg and the speed is slower, while more direct (lower latency). Those ore some of the tradeoffs. There is also more cost per month going with Bloomberg data. I looked into both Thompson (Reuters) & Bloomberg, and the monthly cost ran from about $1000 to upwards of $3000 a month for what I needed.

But the real complexity comes in the form of a proprietary server to handle the low-latency data coming in over the T-1. The T-1 datafeed plugs into the computer that is dedicated to the Bloomberg database, and bear in mind that the low latency real-time, tick-by-tick data requires a complex proprietary database. There are lots of these low-latency databases out there, but here's the key: They have no way of being ODBC compliant because standard SQL-92 is too slow to be used in querying the data that is being colleected. Note this: No SQL due t native speed issues deveolving from the very design of the SQL standard.

So, not only is Bloomberg expensive, its proprietary. And also, you have what is called a "Bloomberg" terminal, which these days can be a PC in your network. But, you don't get anything displaying on your "Bloomberg" unless the T-1 is talking to the server PC, which contains the custom database. Then and only then is data served up to your Bloomberg. Very proprietary, very un-simple, and very expensive.

So whats my point? My point is that "Everyman" can TODAY get SpoozChartz, with a custom scripting language that is functionally identical to TradeStation's EasyLanguage. "Everyman" can TODAY use SpoozChartz to connect to an inexpensive data-feed, performing the actual connectivity via either the Excel spreadsheet side of things or via the SpoozChartz side of things. Either way, no custom database is required before data gets graphically displayed. SpoozChartz can be used to display indicators of a user's own choosing from a huge list of common ones (MACD, RSI. Chaiken, Stochastics, Bollingers, and so forth) OR custom indicators can be designed in Excel or in the TradesStation compliant language, PowerLanguage. Trading signals can be programmatically defined in the same way as is being done by TradeStation users worldwide. As a matter of fact, if you have existing TradeStation code, it drops directly in.

But here's the key: The whole shooting match is very low cost. The only drawback I can find is that the affordable datafeeds are push/pull or client/server rather than streaming. And then there's the database complexity that is necessary to even handle low latency streaming data. My solution is at a fraction of the cost of the solutions commonly available to professional traders. And, any level of complexity can be designed into the solution via ordinary Excel functionality and/or custom TradeStation compliant scripting. IMHO, even without SpoozToolz, I am helped by having taken the time to develop a solution employing SpoozChartz.

And this is available TODAY. Now. I'm doing it.

Representative datafeed costs:
DTN's IQFeed is less tha $80.00 a month. Marketlink is $23.00. Barcharts (via ModulusFe) is $39.00/month for RTD. eSignal is something like $35.00.... I'd have to check because its so low, I never think about it anymore. Now none of these are streaming, but I've tested them head to head in a spreadsheet that collects data identically in each case. The least expensive, Markelink, is as good as any of the others. And, because of the Universal DDE connector, Marketlink can be the DDE data supplier for data displayed in SpoozChartz in real-time. Feed it to Excel and display it in SpoozChartz. Simple as that.

This is real. Fact. I'm doing it. Now. Today. Fact.

Now, one piece remains to be built. I need to answer this question: How do I get from custom Excel spreadsheets generating custom indicators that fire signals in the GUI of SpoozChartz, to an actual autotrading solution?

Answer: SpoozToolz. Simple as that. I intend to autotrade the firing of alerts coming from either my Excel columns or a SpoozToolz PowerLanguage script.. Simple as that.

According to my conversations with CapnDon, SpoozToolz is a "wrapper" for Excel spreadsheet. I know that's not a scientific explanation, but it's the practical effect of what is going on. You can drop existing Excel spreadsheets directly into SpoozToolz, according to CapnDon.

So, I've built my custom Excel Spreadsheet. IMHO, I took what I could get and did something constructive with my time, other than call Spooz devotes "amazing", or "unbelievable", or any other such phrases that imply there is a lack of sentience in the decision to play this stinky pinky. I think its one heck of a lot more productive to have tried to be prepared to take advantage of what I invested my money in, rather than to waste everyone's time cussing about Paul Strickland and trying to convince people this company is a scam. I happen to know its not a scam because of everything I've described above. This company is not a scam. It never was a scam. And it is all but ready to blow the doors off of all of us who have held on to the investment we made in this little wildcat well.

Now, the only codicile is that it may run out of money and never make it out of the hell-hole; but if it doesn't, I think what I've undertaken is going to pay off bigtime. Most folks appear to be in this puppy to make money out of it as a stock. Since its so down in price, they are extremely mad. Fine. I never saw this as just another stock. I saw it as a story stock and the story was that, if used correctly, I will finally be able to create an autotrading "black box" of whatever complexity I can dream up. Break that proverbial glass ceiling and never look back. So, I've done what I can, and one thing I therefore know: this puppy ain't no scam.

Now, lets all take a deep breath and stop acting like this puppy is IBM. Its a stinky little pinky and it is a pathetic mess in terms of its finances. It is still highly likely to fail, just within sight of the finish line. But facts are facts, folks. And I don't care how loud I get screamed at by those who insist that the only facts in this story are failure facts. They are not. The above are facts, ladies and gentlemen. Scream so loud the forest trembles. It makes no matter at all. The fact is that I've taken this puppy to the point described herein, and if this company were a scam, that simply could not be done. Admit or not, the true fact is that there are successes in what Spooz has done, and I know this becasue of all the work I've personally done. End of story.

So, ~6979~, thats a real user's example. Take it or leave it. IMHO, everyone needs to do as I've said to do time and time again: make up your mind that Spooz is a wildcat well and quit griping. It is and always was a high risk, looking for a place to be a disaster. Cussing everyone out who decided to take the risk or cussing out the company is just a waste of emotions. Gets everybody upset. Reminds me of a lynch mob. This is a high risk wildcat well. Simple as that. Take it or leave it. Risk is risk is risk is risk. You can not denature risk.

Imperial Whazoo

**********************************************************************************************************

v/r
Sterling