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.

Touche!


 
[^top^]

Previous Entries
September 15, 2014
Sometime in February 2014, Jeffrey S. Conover sent a written complaint to the Financial Industry Regulatory Authority (“FINRA”) in which he asserted t... Read On
September 13, 2014
BrokeAndBroker Offers A Weekend Musical ExtravaganzaSeptember 12, 2014What's this column about?  Not sure but I thought that I'd just go with it.... Read On
September 12, 2014
What's this column about?  Not sure but I thought that I'd just go with it. It's a Friday afternoon and the Labor Day holiday is behind us and su... Read On
September 12, 2014
Some fights are quick. A quick upper-cut in the first round and, wham, the loser is on the canvass being counted out. Other fights are knock-down-drag... Read On
September 11, 2014
For the purpose of proposing a settlement of rule violations alleged by the Financial Industry Regulatory Authority (“FINRA”), without admitting or de... Read On
September 11, 2014
This is an update of "In Vino No Veritas Says Kurniawan Jury" (BrokeAndBroker.com, December 20, 2013).Before I became a lawyer, I was the third genera... Read On
September 10, 2014
Anti-Money Laundering or AML is a hot button issue for Wall Street's compliance professionals. Given the world of terrorism and organized crime that w... Read On
September 9, 2014
Stockbroker, Compliance, Legal, and Regulatory JobsEmployment Page BrokeAndBroker.com Jobs#wallstreetjobs @brokeandbrokerNOTICE TO EMPLOYERS... Read On
September 8, 2014
Notwithstanding the relatively rosier employment picture of recent months (and there are still many thorns hidden in that employment data), the legacy... Read On
BrokeAndBroker.com Job Search
Related Topics
Tag Cloud
Internet FINRA Bear Stearns Bloomberg SEC NASD NYSE Money Laundering Due Diligence Waiver Forbes China Chepucavage Broy Woody Allen Madoff NAC NPR Marketplace Stanford UBS Ketchum Antitrust NASDAQ RRBDLAW Schapiro Bill Singer BrokerAndBroker USERRA Brokeandbroker.com Morgan Keegan Arbitration Counterclaim BrokeAndBroker.com Khuzami BrokeAndBroker Aleynikov Goldman Sachs brokeandbroker Promissory Note U4 Bill SInger EFL CFTC Huffington Post Flash Crash arbitration RBC RRBDLAW.com Ponzi Affinity Fraud Wachovia Raymond James BrokeandBroker.com Expungement Fraud Securities Fraud Outside Business Activity Registered Rep Magazine FOREX BrokerAndBroker.com FBI Banc of America Pro Se 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 RRBDlaw.com Email Netschi Moore Whistleblower Street Sweeper Tran Bharara Facebook Online Bonus Eligibility Rule TD Ameritrade Hedge Fund SAC 1099 Smith Barney Lehman Brothers IC3 Scottrade 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 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 RRBDlaw Appeal Fowler LPL Johnson US Airways 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 Away Account Credit Repair PN Advisor Placement Group Forex Mortgage Private Placement Moon Merrill Anderson Exam Lee Borrowing Tax Lien Conversion Oppenheimer Wedbush Felony Misdemeanor Expenses ING Lien OTR Estate Jobs Florida Credit Card Elderly Flash Drive Annuity Reimbursement FNMA BrokeAndBroke TIC DWI Promissory Notes Suitability Will POA Power of Attorney Casino NSF MF Global Counterfeit Preet Bharara Corzine Hacker RIA Prison Disclosure NASAA Aguilar FCPA Subway Identity Theft Gold Dell Bar Injunction Bank Deutsche Bank God HSBC Private Placements Eric Stein Wire Fraud CCO Joshua Brown Backstage Wall Street Obstruction of Justice Reuters Retaliation Variable Annuity Outside Account Options Telephone Wine Social Media ADA Pacifico Non-Prosecution Agreement Confirm Tax Fraud Retirement OBA Equity Indexed Annuities EIA 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 Wife Discretion Non-Solicitation Restaurant Commodities Private Securities Transaction Offer of Settlement Money Market employment jobs Great Recession Chase Investment Services Arrest Barclays Liens Failure To Supervise Apple Time And Price T&P Willfully Husband Letter of Authorization LOA Sexism Debit Card Knight Test Practice Sale Unfair Competition Signature Judgments Undisclosed Settlement Trainee Fee Trust Laser Side Bar Mattera Female Sales Assistant Kennedy Charge Sexist NML Argentina Embezzlement Silver Judgment Bank Fraud Deceased TSSB Mary Jo White Trustee Frumento Conspiracy 6th Circuit Proctor Rule 3040 Class Action Beneficiary NYAG Schneiderman Gallagher White Short Sale Compromise Website TRO Supervision Vacatur SDNY BrokeAndBroker Bill Singer Piwowar Rule 1122 Article V signature VA Regulation SP Rule 3270 OWB Stockbrokers
 
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+