V. 19:8 (30): Sidebar: Calculating BMP in a spreadsheet by Igor Livshin
Product Description
Sidebar: Calculating BMP in a spreadsheet by Igor Livshin
To compute balance of market power in a spreadsheet, we’ve used Excel as an example (Sidebar Figure 1). Most other spreadsheets can translate Excel code into their own formats. Begin by importing the data (for plotting purposes), open, high, low, and close as shown. Then, place this code in cell F2 :
=(C2-B2)/(C2-D2)
To compute balance of market power in a spreadsheet, we’ve used Excel as an example (Sidebar Figure 1). Most other spreadsheets can translate Excel code into their own formats. Begin by importing the data (for plotting purposes), open, high, low, and close as shown. Then, place this code in cell F2 :
=(C2-B2)/(C2-D2)
FOR THOSE ORDERING ARTICLES SEPARATELY:
*Note: $2.95-$5.95 Articles are in PDF format only. No hard copy of the article(s) will be delivered. During checkout, click the "Download Now" button to immediately receive your article(s) purchase. STOCKS & COMMODITIES magazine is delivered via mail. After paying for your subscription at store.traders.com users can view the S&C Digital Edition in the subscriber's section on Traders.com.
| Take Control of Your Trading. |
| Professional Traders' Starter Kit |
| All these items shown below only $299.99! |
| Click Here to Order |