An irreverent Wall Street Blog
by Bill Singer
Join BrokeAndBroker blog on Facebook  Follow the BrokeAndBroker blog on Twitter  Connect with BrokeAndBroker on LinkedIn  Join Bill Singer on Google+  Subscribe to RSS Feed

Stockbroker Fined And Suspended For Using Microsoft Excel Spreadsheet
Written: January 5, 2013

Microsoft Excel spreadsheet

Microsoft Excel spreadsheet (Photo credit: Wikipedia)

For the purpose of proposing a settlement of rule violations alleged by the Financial Industry Regulatory Authority (“FINRA”), without admitting or denying the findings, prior to a regulatory hearing, and without an adjudication of any issue, Robert Louis Iola, Jr., submitted a Letter of Acceptance, Waiver and Consent (“AWC”), which FINRA accepted. In the Matter of Robert Louis Iola, Jr., Respondent (AWC  2010024279801, December 31, 2012).

Securities industry veteran Iola was first registered in 1990 and from the relevant time of December 2003 to the present, he was registered with FINRA member firm Summit Equities, Inc. The AWC asserts that he had no prior FINRA disciplinary history.

Hands On

It appears that after several unsuccessful effort to create a single document listing the value and performance of each of his customers’ accounts, starting around January 2007 through December 2010, Iola and his staff gave up on using Summit Equities’ systems and resorted to a more old-fashioned approach: They manually created the desired summaries for at least six customers. This hands-on approach entailed assembling the appropriate account statements and manually inputting the data from those documents into aMicrosoft Excel spreadsheet.

Embedded into the spreadsheet were what the AWC characterizes as “simple mathematical formulas,” which produced:

  • beginning and ending values,
  • net additions/withdrawals,
  • and rate of return (not time weighted).

The data was broken out for each account held by the six customer along with total values for their entire portfolio.  At an in-person account review meeting or through the mail with follow-up telephone conferences, each client received from Iola the summaries. The six customers received at least four summaries per year, in addition to account statements provided by Summit Equities.

Measure Twice, Cut Once

The AWC alleged that although Iola checked the summaries for internal consistency, he did not cross-reference the figures presented on them with the figures in the account statements. FINRA criticized Iola’s reliance on his staff to accurately input the data; and, further, with the exception of the initial spreadsheets, the AWC alleged that Iola did not review the Excel spreadsheets containing the formulas used to calculate the figures in the summaries.  Acording to the AWC, mistakes were made in the gathering and inputting of information, which rendered the summaries inaccurate and misleading.  Among the cited errors were

  • incorrect beginning and/or ending values,
  • withdrawal figures, and
  • rates of return.

Finally, FINRA admonished that for most of the relevant time period, Iola failed to annotate the documents with footnotes or disclaimers that the regulator suggests was necessary to made the date understandable.

The AWC asserted that the absence on the summaries of an explanation or the basis for the calculation of the return figures deprived the clients of a sound basis on which to evaluate their returns. Further, by producing and then distributing these summaries to his customers, Iola was deemed to have violated NASD Conduct Rules 2110 (for conduct before December 15, 2008), 2210(d)(1)(A) and 2210(d)(1)(B), and FINRA Rule 2010 (for conduct after December 14, 2008).

In accordance with the terms of the AWC, FINRA imposed upon Iola the sanctions of a $5,000 fine and a 10 business-day suspension from association with any FINRA member firm in any capacity.

Bill Singer's Comment

I dunno with this one.  I get FINRA’s point and the regulator’s concern but I’m not sure why it was necessary to suspend and fine Iola — frankly, it seems to me that the stockbroker was sort of exercising a well-intentioned attempt at better customer service by providing his clients with what he thought would be helpful summaries. Seems to me that given the stated facts, this was a case of good intentions gone awry. For that, maybe you just call Iola into a room and tell him not to do it again.  I’m not sure that imposing a fine and suspension is warranted or necessary. Alas, the road to Hell is indeed paved with good intentions.

Lost in FINRA’s finger wagging is some discussion about whether Summit Equities’ systems were flawed or overly cumbersome — or, to be fair, whether Iola and his staff were oafish dolts who should have been able to produce the desired reports on their firm’s platform.  Perhaps the AWC should have added some additional footnotes or disclaimers? In the absence of such clarification, I don’t find the sanctions in this AWC offering a sound basis upon which the industry and investing public can base a decision as to the appropriateness and fairness of the fine and suspension.



Previous Entries
July 6, 2015
Ah, yes . . . Germany, France, Spain, Italy, Greece . . . Europe is in turmoil . . . the world awaits news.  Hmmm, where have we heard that befor... Read On
July 3, 2015
On Sunday July 5th, Greeks will be going to the polls -- at least as of the writing of this column -- and voting whether to accept the terms of the pr... Read On
July 2, 2015
Offered for your consideration today in the Blog is a thought piece. On one side, we have the goose: An individual human being conv... Read On
July 1, 2015
If you're going to promise a Wall Street regulator that you will fix a problem, you better make certain -- in fact, you better make damn cer... Read On
June 30, 2015
In "SEC Commissioner Gallagher Rages Against The Dying Light In Two Dissents" (, June 18, 2015), I noted that:After four years ... Read On
June 30, 2015
Stockbroker, Compliance, Legal, and Regulatory JobsEmployment Page Jobs#wallstreetjobs @brokeandbrokerNOTICE TO EMPLOYERS: Brok... Read On
June 29, 2015
On June 26, 2015, the Financial Industry Regulatory Authority ("FINRA") published this somewhat unusual and intriguing press release:FINRA Supports NA... Read On Job Search

Related Topics
Tag Cloud
Internet FINRA Bear Stearns Bloomberg SEC NASD NYSE Money Laundering Due Diligence Waiver Forbes China Broy Woody Allen Madoff NAC NPR Marketplace Stanford UBS Ketchum Antitrust NASDAQ RRBDLAW Schapiro Bill Singer BrokerAndBroker USERRA Morgan Keegan Arbitration Counterclaim Khuzami BrokeAndBroker Aleynikov Goldman Sachs brokeandbroker Promissory Note U4 Bill SInger EFL CFTC Huffington Post Flash Crash arbitration RBC Ponzi Affinity Fraud Wachovia Criminal Raymond James Expungement Fraud Securities Fraud Outside Business Activity Registered Rep Magazine FOREX FBI Banc of America Pro Se PCAOB Supreme Court Morgan Stanley Smith Barney E*Trade Margin email Galleon Penson U5 Defamation Protocol Wells Fargo Punitive Damages Citigroup Merrill Lynch ARS Employee Forgivable Loan Street Legal Morgan Stanley AWC Fidelity Bankruptcy Broke And Broker HFT David Sobel Day Trading Ameriprise Commissions Spouse Schwab Commission CRD Kenneth Starr IRS CNBC Complaint ATM Skimming Hacking Phishing Malware Naskovets Poteroba Koval Lincoln Financial Selling Away Outside Business Activities Rakoff 2nd Circuit Second Circuit IRA 401k Forgery Tax Email Netschi Moore Whistleblower Street Sweeper Countrywide Tran Bharara Facebook Online Severance Bonus Eligibility Rule TD Ameritrade Hedge Fund SAC 1099 Smith Barney Lehman Brothers SIPC IC3 Scottrade AIG Lehman JPMorgan Chase Hertz Insider Trading Bank of America Department of Justice Elles Bribe Auction Rate Securities Raiding Spam Edward Jones Medicare Diabetes Dow Schumer Thain Walter Bid Rigging Real Estate Discrimination Wall Street Statutory Disqualification Form U4 Form U5 Indictment Boyland DOJ Corruption bill singer FTC Do Not Call FINRA Arbitration Costa Rica Settlement LIBOR Varney Plea Rule 8210 Eligibility RRBDlaw 8210 Appeal Fowler LPL Johnson Cellphone US Airways JPM BrokeandBroker Reg D MSSB Vault Loan SunTrust Discovery Employment Rosenthal Recruiting Lawyer Trading Platform JP Morgan Employment Tuesday Wrongful Termination Bank Guarantee WaMu Solicitation REIT Martin Credit Cards Rule 3050 Away Account Credit Repair PN Advisor Placement Group Fifth Amendment Forex Mortgage Private Placement Moon CGMI Failure to Supervise Merrill Anderson Exam Lee Borrowing Tax Lien Charity Conversion Oppenheimer Wedbush Felony Misdemeanor Expenses ING Lien OTR Estate Jobs Florida Credit Card Elderly Flash Drive Annuity Expense Reimbursement FNMA BrokeAndBroke TIC DWI Promissory Notes Suitability Will POA Power of Attorney Casino NSF MF Global Counterfeit Preet Bharara Corzine Hacker Deferred Compensation RIA Prison Disclosure NASAA Aguilar FCPA Subway Testimony Identity Theft Gold Dell Bar Injunction Bank Deutsche Bank Hospital Retirement Due Process God HSBC Private Placements Eric Stein Wire Fraud FINOP CCO Compliance Audit Test Examination Cheating Joshua Brown Backstage Wall Street Obstruction of Justice Reuters Retaliation Variable Annuity Arbitraiton Outside Account Options Telephone Wine Series 7 Social Media ADA Pacifico Non-Prosecution Agreement Confirm Tax Fraud OBA Equity Indexed Annuities EIA Disability MetLife Continuing Education OIP Tax Liens Willful CE Unregistered Impersonation Annuities BBVA Business Expenses ETF JOBS Act Mail Fraud Parking Variable Annuities Signatures BitTorrent Impersonator Wire Transfer Wire Crowdfunding Nasdaq Away Accounts WSP Laptop Dodd Frank Checks RMBS AML PST Solicited Unsolicited Congress SRO Password Wife Discretion Non-Solicitation Restaurant Commodities Private Securities Transaction Offer of Settlement Money Market employment jobs Great Recession Chase Investment Services Arrest Barclays Liens Obamacare Failure To Supervise Apple Time And Price T&P Willfully Husband Letter of Authorization LOA Sexism Debit Card Knight Practice Sale Unfair Competition Signature Judgments Data Undisclosed Settlement Trainee Fee Trust Laser Side Bar Mattera Female Sales Assistant Kennedy Charge Commodities Fraud Sexist NML Argentina Embezzlement Silver Investor Alert Evidence Judgment Bank Fraud Deceased Bill Singer BrokeAndBroker TSSB OHO Leveraged ETF Mary Jo White Trustee FINRA AWC Motion To Dismiss Frumento Conspiracy 6th Circuit Proctor Commissioner Stein 401(k) Rule 3040 Customer Files Class Action Beneficiary NYAG Schneiderman 11th Circuit Insurance Gallagher White Self Regulation Short Sale Compromise Website Rule 2010 Check TRO Supervision Vacatur Remand SDNY Rule 12206 BrokeAndBroker Bill Singer Piwowar Stifel Rule 1122 Article V signature Confidential Inside Information Reg SP VA Leveraged ETFs Regulation SP Fees Cease And Desist Customer Rule 3270 Rule 3240 Annual Compliance Questionnaire OWB 2Cir Red Flags Payroll Stockbrokers ALJ Cybercrime Loans BrokerCheck Altered Records
Email Bill Singer Connect with Bill Singer on Facebook Follow Bill Singer on Twitter Link up with Bill Singer on LinkedIn Join Bill Singer on Google+