Friday, August 24, 2012

Dabama Song

First Video the Obama Song, really hilarious, whether you love him or hate him, it is hilarious either way. Second Video --Nickelback--no joke here, Nickelback chills in Maui and they own a sibling of my older dog, bought from same breeder. Plus they are of my few liked semi-modern bands.

Thursday, August 23, 2012

Food Solar Cycles and Sunspots

Sorry humans, it's time to humble down a bit, its in your own interest to realize that there are things larger than our own ego.    In fact, things that happen 93 Million miles away can affect what we do, and how we proceed with our lives.

I have researched this for half a decade, and their are some good books devoted exactly to the subject of sun spots and their effect on weather patterns, food, and business cycles.

Hence, removing one of the layers of deception...self deception that thing external to ourselves may in fact be very important.

This doc is from ZeroHedge who (y'all know that Tyler Durden is actually a bunch of people and that the name comes from Fight Club), who has been doing some spectacular writings lately.

I added it to my blog so it is easy to reference later, i.e. type in "sunspots"


https://www.box.com/s/c6c90935967cef394955

Charts for Wednesday

First Chart from Doc J I am feeling quite bullish...hints of QE and todays salivating bears. However, the Great British Pound / USD currency pair, called the Cable, has hit my long term target, at least touched the bottom. A reversal down, would make it hard for US Equities to go up. So US will print, while Obama implements some shenanigans to keep oil prices (or at least gas) from going up too much. That way Cable can continue to go up, and USD can go down so Equities can go up. Funny how this can be performed so that one man can keep his job. Second chart is the Cable, target is hit, now what?




Wednesday, August 22, 2012

Big Bro

Big Bro -- He Got Your Backside and remember, you didn't build it, McDonalds did.

Teleprompter in Chief, like we all need a TIC

Faber Overall Report on Keynesian insanity

In as-comprehensive-an-explanation-as-we-have-seen of the monetary malfeasance and misunderstanding of the standard Keynesian central-banker, Gloom-Boom-Doom's Marc Faber addressed an institutional audience in the Middle East earlier this year



Aug 22 Boatload O Charts

Some charts I popped off.     See my how to buy PM's writeup, right before the launch of PM's









Monday, August 20, 2012

To dream, rechance to rant.

First of all we need to restore the Constitution,

Then we need to restore the rule of law,

OK good start,

Now break up the big banks aka brokers, and also force them to divest all of their media ownings,

Put incredible limits on lobbying as a paid profession, and on campaign contributions

Limit terms on government and don't let anyone become a career politician, after 12 years you MUST go to work in the real world IF you want to return to government and than it for 3.5 years.   

OK now bring home all (90%) of the fine men and women of the US military and retrain them and build a new solar.wind.geothermal energy infrastructure to provide 90% of all we need, and do that in the next 10 years. 

In the mean time revisit our education system, it needs help.   

OK--now we are ready to tackle the real tough problems, but first get our house in order.

SLV getting some lovin' and AFFY

AFFY: (originally a BPT trade idea)
This swat down on the pop is actually long term thin tail resistance.
I went long on the retrace to the near term thin tail support.



Sunday, August 19, 2012

Real time ticker analysis in Excel using Thinkorswim

This article quoted from
http://readtheprospectus.wordpress.com/2009/09/06/linking-excel-and-think-or-swim-for-streaming-real-time-calculations/

I wanted a detailed copy here, because this is great stuff, how to "program" analysis of realtime data.   I have a number of theories that I would like to test and turn into trading edges.

You may have saw my Total Assets of the World post, in which I tallied up, well all the assets in the world.   

 http://oahutrading.blogspot.com/2012/08/summary-of-all-money-in-world.html

I would use a similar approach for  Liquid and Tradable Assets, it would be very interesting to note if the sum total of various asset classes were being bid up, bid down, or whether it just more of a sector rotation --- a shifting of money from place to place to blow out stops.  
 ----------------------------------------------------------------------------------------------------------------
Importing Watch Lists to Excel and Saving the Quote Data
To move a watchlist from Think Desktop into Excel, go to your “MarketWatch” tab, choose “Quotes” and pull up the watchlist. You can build your own, or choose from a lot of built-in lists by clicking the “gear” icon in the upper right:
Choose_Watchlist
From that menu, either create a new watchlist or scan query, or choose a public list like the S&P 500. Next, click the “printer” icon, and you’ll see an option to “Export”:
Export_Menu
If you click “Export”, you can save the current list, symbols and associated data as a .csv file. Then you can open it in Excel or your favorite text editor and see your symbols and saved data values. Now, saving these watchlists is nice and all, but we want the Holy Grail: performing real time calculations in Excel on streaming data for multiple symbols at once.
Streaming Real-Time Quotes in Excel
There are actually two ways to get this working–one from Think Desktop itself, and the other from within Excel.
From Think Desktop:
To create a linked Excel file, simply go into Think Desktop to the “MarketWatch” tab, then “Quotes” like before. Choose the watchlist you want to get data for, or create a new one, same as above. Then click that “printer” icon again, and this time choose “Export to Excel” (you know, the one you wanted to click before, but you waited until now, right?). You’ll get a message that your data is ready to paste into Excel:
Paste_Notice
Now go to your Excel file (an existing one or create a new one), choose a cell and paste (ctrl+v). You will see a bunch of #N/A’s at first, then after a few seconds the streaming will kick in. Your watchlist is now in Excel and streaming data! It will keep doing so as long as Think Desktop is open and connected to Think or Swim. If you save the Excel file and close it, you can use it again later. The links will remain, but you have to open Think Desktop and connect to Think or Swim first. When the Excel file is opened, it will ask you if you want to update links from another workbook–it’s talking about the links to Think Desktop. Click “Yes” or the data won’t update. And now you know the easy Think Desktop “Export to Excel” method!
From Inside of Excel:
The data linkage to Think Desktop is done through an Excel capability called Dynamic Data Exchange (DDE). Basically, you just enter a special formula in a cell with certain arguments and Excel does the rest. This is the way you can create a linked file from outside of Think Desktop. (Think Desktop actually does the same thing when you click “Export to Excel”–it builds these formulas for you according to how your “quotes” screen is set up and puts them on the clipboard ready to paste in Excel.)
To get the last price of GOOG, you would enter this formula into a cell:
=TOS|LAST!’GOOG’
“TOS” is an identifier for the Think Desktop program that is running (which is not coincidentally named “TOS.exe”). The “|” (the pipe character) is a separator that tells Excel that “TOS” is a program to use DDE with. The “LAST” is an available data field in Think Desktop; there are 70 different fields you can use currently, which can be seen by clicking the “printer” icon and choosing “DDE Help”:
DDE_Help
Next in the formula, you put in a “!” as another separator, and then the string ‘GOOG’ tells Excel what symbol to get the data for. That’s it! As another example, to get today’s volume for AAPL, you would use the formula:
=TOS|VOLUME!’AAPL’
When you know this syntax, you can build your own quote sheet from scratch without even exporting from Think Desktop. Just type in the formula, and as long as Think Desktop is running and connected to Think or Swim servers, the link will just work. Amazingly awesome if you asked me.
So What?
You may be thinking, “So what’s the big deal? I can watch quotes from Think Desktop.” Well, here’s just a couple of examples to give you an idea of what you could do with a tool like this:
You could calculate a volume-weighted average put/call ratio for every stock in the Russell 3000 in real time.
You could show the average bid/ask spread for every stock in the S&P 500, watching the number for when average spreads widen or contract for a sense of broad market liquidity.
The possibilities are almost endless!
I’ve created a couple of Excel files that can help get you started. These files are freely available (though donations are appreciated) on my Google site, under the “Released Tools” section, in “TOS_Excel_DDE.zip”. The first file, “TOS_DDE_Examples”, has the two examples mentioned above. The second file, “TOS_DDE_Template” is a blank template sheet ready for you to enter your tickers, choose your fields from the drop downs, click “Generate” and go! In general, I’d recommend running no more symbols, fields or files than necessary to minimize processor and network overhead. Also, as in the examples file, I would separate the sheets that do the importing and the sheets that do any of your calculations.
Coming Soon: Complex Analysis for Tool (CAT) for Using Think or Swim Data in Excel
But wait!! There’s more! The tool above only shows you the most recent data values. Using some macros and other trickery we can save the historical data and calculate complex values back through time for every symbol in your watchlist all at the same time. In addition, we can use VBA and other controls to add capability for alerts, whether through a cell color change, a pop-up alert box, or even sending an email.
I’m working on I’ve released a Complex Analysis Tool (CAT) for my blog donors to do all of this. What could you do with this tool? For example:
You could watch for the highest value of RSI(10) for every stock in the S&P500 on a 5 minute bar timeframe and pop-up an alert when one breaches 90%.
You could watch for the top 5 stocks with the biggest change in volume over the last 10 minutes.
You could set an alert for every stock in the Dow, sending you an email when any stock touches its own daily pivot level.
You could calculate a real-time TICK for the S&P 500 for use with the ES futures.
The possibilities are even more almost endless!
This tool is not yet finished! But when the CAT tool is ready, I’ll make it available to blog donors only over on my Google site, in “Released Tools”, in the “Donors Only” folder. If you want to donate, just hit my Paypal link and throw me a Jackson ($20 for those from out of town). Or a Franklin, I’m not picky ;-)