## Constructing the Monetary Model by Martin Zweig

This is a discussion on Constructing the Monetary Model by Martin Zweig within the Economic & Fundamental Analysis forums, part of the Methods category; Hello! I have read Martin Zweig´s book Winning On Wall Street and liked it very much. Now I´m trying to ...

Feb 17, 2006, 6:06pm   #1
Joined Nov 2005
Constructing the Monetary Model by Martin Zweig (US Markets)

Hello!

I have read Martin Zweig´s book Winning On Wall Street and liked it very much. Now I´m trying to construct the Monetary Model, which he developed, but I got stuck.

The Monetary Model is constructed from Prime Rate Indicator, Fed Indicator and Installment Debt Indicator.

Prime Rate Indicator:
This was not much trouble to find.

Fed Indicator:
This indicator is constructed from discount rate, federal funds rate and reserve requirements.

Discount Rate and Federal Funds Rate:
According to Zweig, both the discount rate and the federal funds rate serve basically the same function so he uses changes in either rate for calculating the Fed Indicator.

One useful site that I found publishes Primary rate, Secondary rate and Federal Funds Rate. The Primary and Secondary rate are not mentioned in his book, so I wonder, which of these should I use?

Reserve Requirements:
I have no idea where to find this data. A quote from his book:
Quote:
 "To calculate the Fed Indicator, you must grade the discount rate and reserve requirements separately. Then their scores are combined. In the following examples, I´ll stick with just the discount rate, but the rules would work exactly the same for reserve requirements. (At this writing, the Fed hasn´t touched reserve requirements since the fall of 1981.)"
I would very much appreciate if someone could direct me to somewhere, where I can obtain this data.

Installment Debt Indicator:
I understand, for what is it used, and that it is reported once a month, but again, I don´t know where to find the numbers.

Any help is appreciated and when the Monetary Model Worksheet is completed (MS Excel format) I´ll gladly share it with you.

Last edited by pirx; Feb 17, 2006 at 6:29pm.

Mar 2, 2006, 7:36pm   #2
Joined Nov 2005
This has taken a lot of time, but my interpretation of the Market Model is now constructed and available in the attachment.

There are some Slovenian comments in the cells, but you can simply delete them. The requested data also needs to be entered, but this is the least

Enjoy.

UPDATE:
The attachment now contains all of the existing conditions for March 2006.
Attached Files
 Zweig Super Model.xls (54.0 KB, 1927 views)

Last edited by pirx; Mar 5, 2006 at 10:01pm.

 The following members like this post: royallap
 Jul 12, 2006, 4:03pm #3 Joined Jul 2006 Downloaded your Zweig model. Thanks. Could you summarize where you get all the data in the model? Thanks again
Jul 12, 2006, 9:15pm   #4
Joined Nov 2005
Quote:
 Originally Posted by royallap Downloaded your Zweig model. Thanks. Could you summarize where you get all the data in the model? Thanks again
Hello! I hope you find it usefull.

Since there are too many links to copy/paste, I suggest you to try some googling. If you won´t find all of the sources, let me know, and I´ll help.

Aug 16, 2006, 8:34pm   #5
Joined Aug 2006
INstallment debt

How to calculate the Consumer Installment Debt? For example, in his book, the number 3/18/74 is \$145.55 Billion. But the http://www.federalreserve.gov/releas...c_hist_nr.html
it shows on January 1974, the number was \$191.222 Billion. Do you know where this \$145.55 Billion came from? Thank you for help.

Quote:
 Originally Posted by pirx Hello! I hope you find it usefull. Since there are too many links to copy/paste, I suggest you to try some googling. If you won´t find all of the sources, let me know, and I´ll help.

Aug 16, 2006, 8:39pm   #6
Joined Aug 2006

How to calculate the Consumer Installment Debt? For example, in his book, the number 3/18/74 is \$145.55 Billion. But from the http://www.federalreserve.gov/relea...cc_hist_nr.html
it shows on January 1974, the number was \$191.222 Billion. Do you know where this \$145.55 Billion came from? Thank you for help.

Quote:
 Originally Posted by pirx Hello! I hope you find it usefull. Since there are too many links to copy/paste, I suggest you to try some googling. If you won´t find all of the sources, let me know, and I´ll help.

Aug 17, 2006, 5:48pm   #7
Joined Nov 2005
Quote:
 Originally Posted by viamlvictor How to calculate the Consumer Installment Debt? For example, in his book, the number 3/18/74 is \$145.55 Billion. But from the http://www.federalreserve.gov/relea...cc_hist_nr.html it shows on January 1974, the number was \$191.222 Billion. Do you know where this \$145.55 Billion came from? Thank you for help.
The difference is small enough, so don´t worry

But, the truth is, that I don´t know from where the difference comes from. If you start to follow G.19 reports monthly, you will notice, that every single number changes for just a little.

For example - on January 2006, I´ve recorded 2185028 for total Consumer Credit. If you look at it now, it´s at 2177280.

Aug 26, 2006, 12:52am   #8
Joined Aug 2006
Value line index

Pirx,
Thank you for reply to my question. Thank you for help. Do you know where can I fine the data of the Value Line Composite?
Thanks.

Quote:
 Originally Posted by pirx The difference is small enough, so don´t worry But, the truth is, that I don´t know from where the difference comes from. If you start to follow G.19 reports monthly, you will notice, that every single number changes for just a little. For example - on January 2006, I´ve recorded 2185028 for total Consumer Credit. If you look at it now, it´s at 2177280. Maybe we should ask the FED why this differences are made.

Aug 26, 2006, 9:56pm   #9
Joined Nov 2005
Quote:
 Originally Posted by viamlvictor Pirx, Thank you for reply to my question. Thank you for help. Do you know where can I fine the data of the Value Line Composite? Thanks.
You can find it right
here.

 May 7, 2007, 10:11am #10 Joined Oct 2005 Zweig Super-Model Hi Pirx I was about to embark on developing and populating a spread-sheet for Zweig's super-model. As with everything in the markets, nothing is new and I see you have already created a spread-sheet. Have you populated it and kept it up-to-date? Did you ever add the links to the source data? If you are willing to share your latest efforts I would be very grateful, it will save me quite a bit of time. Otherwise, I will just plough on anyway. As an aside, have you read Timing the Market by Deborah Weir? She builds an S&P model based around the yield curve ("the best from the world of fundamental analysis"); the number of advancing stocks in the Dow ("the best from the world of technical analysis") when confirmed by VIX or put/call ratio or debt margin/short interest; and the call-up of troops to war ("the best from the world of cultural indicators"). If you liked Zweig, you'll probably like Weir. Best regards Steve
 May 7, 2007, 10:26pm #11 Joined Nov 2005 Hello, Stevoswing. Sorry that I´m a bit late with my answer. Yes, I am updating the worksheet weekly and I even made it look better But I decided to open a financial blog and this worksheet is going to be one of the features available to members only. Anyway, I´m willing to send it for free to you. It´s not an editable version, but it should help a LOT if you plan to constuct it by yourself. Let me know where to send it. (I´ll check if I can send it to you via PM - if yes, you should get it shortly) By the way, I did not read Deborah´s book, but it seems interesing. Thanks for the tip. Have a nice day! H.
 May 8, 2007, 8:57am #12 Joined Oct 2005 Zweig spreadsheet Pirx Thank you very much for replying. Using someone else's spread-sheet is a bit like using someone else's toothbrush. Not very pleasant but always better than nothing! I have started constructing my spread-sheet but your version will be extremely valueable to have alongside, to double-check method and data. I'm an infrequent poster to T2W so I'm not sure of the protocol for you to send a file to me - do I simply tell you my email address in one of these messages, or do you have access to it somewhere through the site? Many thanks Steve
 May 8, 2007, 9:54pm #13 Joined Nov 2005 Steve, you can send me a personal message with your email address. As soon as I´ll have your contact information, I´ll send you the spreadsheet. I would also be very grateful, if you could show me your version, when it´s finished. Best regards. Henrik
 Jun 25, 2007, 9:43am #14 Joined Nov 2005 Hi everyone, I just want to say, that the full Market Model is now available at http://www.activeinvestorsblog.com/ Enjoy your day
May 25, 2008, 11:27pm   #15
Joined May 2008
Super Model

I was interested in the spreadsheet for the supermodel and tried the website but it wouldn't pull up. Could you send the spreadsheet to my email address?
Thanks
J

Quote:
 Originally Posted by pirx Hi everyone, I just want to say, that the full Market Model is now available at http://www.activeinvestorsblog.com/ Enjoy your day