Each row has Now you need to identify 30-day window. For instance, this would be the case if the bonds or preferred stock are convertible into common stock that has no restriction, has the same voting rights as the common stock, and trades at a price close to the conversion ratio. python wash.py -w dummy_example.csv -o out.csv. Accessed April 14, 2020. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. For high frequency traders, though, the wash rule can make it difficult to report losses in actively traded names. Security (stock) name up to 80 characters long with no imbedded commas; in the workbook. To claim the adjustment, enter the sale of the repurchased securities on Form 8949, but add the disallowed loss amount to the cost of the repurchased securities. examples: 02/04/04, 02/04/2004, 2/2/04, etc. To include these fields in the input file, Option strike price Do not use decimal points; eg., 42 1/2 not 42.5 or blank for stock; Optional. This is set to true when the lot is used as a replacement in a wash sale. Investopedia does not include all offers available in the marketplace. Company | Developed By SBA. 3. A wash sale can delay a tax deduction. Accessed April 14, 2020. Click here to download an excel template for the input file. This field is not used in the calculation but is included in the output file; The amount of the loss must be added to the purchase price of the security you bought that breached the wash-sale rule. Input File - name and directory (full path) where the input file can be found; 2. After you've selected your options, click the CALCULATE button to start the program. The brokers who support import type OFX server, can get import trade history from online brokerage in a fast and easy manner. Option expiration month 2 numeric positions, 01 through 12 or blank for stock; On December 15, the value of the 100 shares has declined to $7,000, so you sell the entire position to realize a capital loss of $3,000 for tax deduction purposes. 2. Internal Revenue Service. MORE DETAILS! Cost whole dollars only, maximum of 10 digits with no commas; Are you sure you want to create this branch? Once the Save As window opens, scroll down the file types until you see Comma Delimited. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple. Fields 9 and 12 may be negative and contain a ''. "Rev. Receive tax deductions that you've planned for instead of having them disallowed, Can work with the rule's waiting period and important end-of-year tax dates, Buy appropriate, related securities (after selling your original position) to still get the appreciation you're expecting, Avoid repercussions of breaking the rule while staying in the market, Can know when the rule has no impact on your transactions. calculation methods: 11. A Service of iTips, Internet Tax Information Processing Services, Inc. Website: You may use the original worksheet name since Excel appends a different suffix to the name indicating the files type. When in doubt, investors wishing to comply with the wash-sale rule should consult with an appropriate tax advisor or other qualified professional. Number of shares/lots maximum of 10 digits with no commas;(show short sales as negatives) You calculate the wash sale when you fill out Form 8949 detailing your capital gains and losses. If Fields 9 or 12 are negative, please use a '' and not parentheses. Free Downloads: Calculate Wash Sales Excel. "Publication 550: Investment Income and Expenses (Including Capital Gains and Losses)," Page 57. Now that you've created and saved your input file in the correct format, you're ready to calculate your wash sales. Once you've selected your options, click the CALCULATE button to start the program. Optional but recommended. 1. Shares of different companies are not usually considered substantially identical, nor are preferred and common shares of the same company, unless the preferred shares are fully convertible into common stock, have identical voting rights and subject to the same dividend restrictions. He has 8 years experience in finance, from financial planning and wealth management to corporate finance and FP&A. MAUS SellBizPro. The deduction you normally would take from a capital loss becomes a disallowed loss in a wash sale, which is marked with a code of W. You add the disallowed loss as an adjustment to the wash sale, thereby giving a total loss of zero. The following section describes the job parameters found on the calculation screen. It occurs when you sell a security for a loss and buy it back within 30 days. The following section describes the job parameters found on the calculation screen. The exact wording of the IRS rule is that a wash applies to the purchase of "substantially identical" stock. Our program keys off the text in the headings. For example, a company involved in a reorganization will likely be considered to have substantially identical securities to those of the new company. report for the purpose of better informed investments. The input file can be either an excel worksheet or a csv file. Consider selling some, but not all, of the shares you own for a loss and leave it at that. Output value may go onto IRS form 8949. It's as if it never occurred. According to the IRS, this postpones the loss deduction until the security is sold. Date of first purchase (tax lot) Sales Commission Calculator . Use Git or checkout with SVN using the web URL. JavaScript is disabled. Once that period ends, the wash-sale rule won't apply to transactions involving the same or similar security. I'm working on a spreadsheet to track the stocks I have purchased and sold and would like to create a formula to determine if a stock I buy would be allowed without triggering a wash sale. If you use the quantity column, do not also include the quantity (number of shares) in this column. Wash trading is the illegal process of buying shares of a company through one broker while selling shares through a different broker. 11. Reviewed by Ryan Cockerham, CISI Capital Markets and Corporate Finance. The offers that appear in this table are from partnerships from which Investopedia receives compensation. Learn more. Remember this name since you will have to tell it to Washems!. Though a loss may be disallowed due to the wash-sale rule, the amount of that loss will be added to the cost of the purchase that triggered the rule. Internet Tax Information Processing Services, Inc. in finance from DePaul University. This would go into the IRS form 8949. The intent of the wash-sale rule is to prevent taxpayers from claiming artificial losses from the sale of securities while essentially maintaining their position in the securities. Use of this column is optional. 5. Why use TradeMax calcuate my Capital Gains & generate schedule-D, Intelligent Option Cost Basis Adjustment To 'TradeMax Support Team' : I applied the fixes, Numbers balance to the penny now. Unfortunately, the IRS does not specifically define what the term substantially identical means. Transactions so noted are reported on a separate copy of Form 8949 (with box C or F checked). On December 27 of the same year, you purchase 100 shares of XYZ tech stock again to re-establish your position in the stock. E.g., "Line 1" for the first lot on the 1099b. Unique Lot Id unique user defined identifier up to 50 characters in length. License: All | Free Freeware. The input file can be either an excel worksheet or a csv file. Date Acquired in the format mm/dd/yy or mm/dd/yyyy; Accessed April 14, 2020. Easy steps to generate Daily Account/Portfolio calculation methods to use for the desired year(s): 10. A wash sale occurs when an investor closes out a position at a loss and buys the same security (or a substantially similar one) within the 61-day wash sale period. V)>nA`drl[JP ,ah*e U=lK@X% ,r]KH!@ ..fL8Lj l~pBv3ma~4p^6vmP.X4 The form contains separate sections for short-term and long-term capital gains. The timeframe for the wash-sale rule is 61 days. You can take any video, trim the best part, combine with other videos, add soundtrack. )O Register To Reply 01-22-2005, 03:06 PM #2 Don Guillett Guest Re: Wash Sale Formula More info on your setup would be needed. The sale of options (which are quantified in the same ways as stocks) at a loss and reacquisition of identical options in the 30-day timeframe would also fall under the terms of the wash-sale rule. Washems2021! Capital Gains Tax Calculation Worksheet A downloadable tax calculator workbook using Microsoft Excel that displays tax rates and location codes, calculates totals, and summarizes sales by city or county without an online connection. You may enter "Various" where applicable. Aggregates Multiple Accounts Trade Data. When its completed, you'll be able to see and download your results. Cost basis ( May 16, 2018 LBI Vacation Rentals & Sales. . I just got TradeMax, it is really amazing. IRA Rules for Selling Stocks & Reinvesting. If your transaction violates the wash-sale rule, the loss you try to take as a tax-deduction will be disallowed. In order to comply with IRS guidelines, you will not be able to deduct any losses from a wash sale on your tax return, although they will still have to be reported on your Schedule D form. Name of stock or other security 3. Internal Revenue Service. 6. Wash sales get canceled out. (This field is used because shares from a given buy lot can't replace shares from the same buy lot in a wash sale). If you repurchase the securities in an individual retirement account, you permanently lose the deduction. 5. It may not display this or other websites correctly. Normally, you deduct your trading losses from your capital gains, but the rules for wash sales postpone the deduction until you sell the repurchased securities. You can help keep this site running by allowing ads on MrExcel.com. Everything is automated. Basically my spreadsheet will look like this: Where if I type in a stock ticker, for instance AAPL, it will tell me if I sold it at a loss in the past 30 days. According toRevenue Ruling 2008-5, IRA transactions can also trigger the wash-sale rule. Warning Report Asks the program to include a report in the results file showing all realized losses that would be lost if a 10. If nothing happens, download GitHub Desktop and try again. "Publication 550: Investment Income and Expenses," Page 56. Handle most wash sales easily Apart from capital gains calculation, TradeMax 2017 also calculates several Wash Sale scenarios, including but are not limited to, Wash Sale between identical securities ( stocks and options ), Wash Sales on an unequal number of securities and Wash Sale on Same Day Rule. License: All | Free Freeware. Non-USD transactions and foreign account, https://www.americancentury.com/index.jsp, http://www.ameriprise.com/default-home.asp, https://www.usaa.com/inet/ent_logon/Logon. Input . Excel Maintenance Services, Inc.. I've provided a dummy one called dummy_example.csv. In this case, while the loss of $300 would be disallowed by the IRS because of the wash-sale rule, it can be added to the $3,200 cost of the new purchase. If you understand the ins and outs of wash sales as well as the wash-sale rule, you'll be able to make the most of legitimate tax breaks without running afoul of the IRS. Summary Reports are no longer being automatically included at Free Downloads: Excel Wash Sale Calculator. Generally can be left blank. Click here to download an excel template for the input file. You purchase 100 shares of stock XYZ on December 15, 2021 for $10/share ($1,000). You folks are fantastic. Powered by designyours. Cost whole dollars only, maximum of 10 digits with no commas; Straddle Calculation Lets the program know if a Straddle Calculation report should be included in the results file and, if so, which of the following If the 100-share position was acquired through multiple purchases, only some of which occurred within the 30-day window, then only the loss on those shares purchased in the window would classify as a disallowed loss. Then, when you do sell those recently bought shares, the adjusted cost basis will be used to figure your gain or loss. Graphical Reporting Work fast with our official CLI. Summary Report Breaks Controls the summary totals to be included in the output file. I believe I have a much better understanding of your software now and will be highly recommending it to my client. multi sheet excel workbook now gives you even more detailed output reports! If you're unaware of the wash-sale rule and inadvertently re-establish a position in the same or similar securities within the rule's wait period, your tax deduction will be disallowed. trade history, auto-converts 2. Sirinarth Mekvorawuth / EyeEm/EyeEm/GettyImages, IRS: Publication 550 (2017), Investment Income and Expenses, Wash-Sale Rules | Avoid this tax pitfall | Fidelity, MarketWatch: Opinion: The wash sale rule is a nasty little piece of tax code. A wash sale is trading activity in which shares of a security are sold at a loss and a substantially identical security is purchased within 30 days. Optional. .03Mz}f0 ]ITc2FO8|%"ZJDpQZ8IvE=&i^ENk0;bF#*n+*mi> If two lots were acquired as part of the same buy order, put the same value here. It might be a funny scene, movie quote, animation, meme or a mashup of multiple sources. Option Conversion Used to determine how the value in the quantity field for options should be treated: 9. For instance, investors often use tax-loss harvesting to cut their taxable income. "Publication 550: Investment Income and Expenses," Page 56-57. Your Excel work file, for example will have the name whatever.xls and your saved csv file will be called whatever.csv. If you'd rather use a csv file as your input, each transaction must be on its own line, contain no embedded commas in the numeric fields and use a Say you buy 100 shares of XYZ tech stock on November 1 for $10,000. no limitation on the size of the output files, a new Tax Unrealized Report and much more! Wash-Sale Rule: An Internal Revenue Service (IRS) rule that prohibits a taxpayer from claiming a loss on the sale or trade of a security in a wash sale. Internal Revenue Service: Publication 550: Investment Income and Expenses, Internal Revenue Service: Form 8949: Sales and Other Dispositions of Capital Assets, Internal Revenue Service: Instructions for Form 8949, BBC News: Royal Bank of Canada Accused of 'Wash Sales Fraud'. You thus reap the tax benefit from the $500 loss on the wash sale by reducing your gain on the second sale by $500. Merger Date mm/dd/yy or mm/dd/yyyy or blank; You do this by clicking on the File option in Excels toolbar and then selecting Save As. Once the wash-sale rule wait period ends, sell your shares and collect your loss. Add the AutoFilter icon to the Quick Access Toolbar. Gain or Loss whole dollars only, maximum of 12 digits without decimals and commas or blank if the lot is still open. The rule defines a wash sale as one that . Then sell your position (perhaps at even a greater loss). TradeMax converts the foreign securities cost basis into USD figures, so that I can estimate gain/loss on USD cost basis. Wash Sale Formula I have stock trades in a excel spreadshhet in which I need to look 30 days previous and 30 days pat to see if that same security was traded - If so figure the gain or loss of the 90 period of that security. Each row on Form 8949 represents a particular sale transaction. - The Ultimate Wash Sale and Constructive Sale Calculator - free Demo NEW VERSION! Input must have this set to 0. Export Form 8949 Report and other The new cost basis, therefore, becomes $3,500 for the 100 shares that were purchased the second time, or $35 per share. "FIFO","LIFO", or "Special ID". Proceeds whole dollars only, maximum of 10 digits with no commas or blank if the lot is still open; 1. Internal Revenue Service. Ordinarily, losses on stocks can be used to offset gains and thus lower tax liability. The columns do not have to be in the order shown here. Since a lot may only be used as a replacement once, you can prevent a lot from absorbing a loss in wash sale computation by setting this to true. Option Conversion Used to determine if the value in the quantity field for options should be. With TradeMax's help, I can track my trade performance easily, analyze my gains/loss cross years and calculate security cost basis for each stock. When you're ready to build a worksheet to calculate your capital gains or losses, try to do the following: Make one worksheet for each stock, bond, or other investment you have. Q:My broker provides cost basis report with wash sale adjustment, why do I still need Trademax? You repurchase 100 shares of XYZ Corp. on July 21 for $27 a share and sell these shares on Nov. 15 for $37 a share. Aller la page d\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'accueil. Keys off the text in the quantity ( number of shares ) this... Movie quote, animation, meme or a csv file it back within 30 days [! Also trigger the wash-sale rule should consult with an appropriate tax advisor or other qualified professional excel Maintenance,. Basis report with wash sale Calculator - Free Demo new VERSION XYZ tech stock again to re-establish position. Ends, sell your position ( perhaps at even a greater loss ) to client! Will be used to determine how the value in the correct format, you 're to... Does not include all offers available in the output file, the loss deduction until the security is sold called. Processing Services, Inc. in finance from DePaul University, do not have to be included in the.! Stock ) name up to 80 characters long with no commas or blank if lot... Inc. in finance from DePaul University you can take wash sale calculator excel video, the... Option Conversion used to figure your gain or loss whole dollars only, maximum of 10 digits no. Washems! lot is still open, for example will have the name whatever.xls and saved. Multi sheet excel workbook now gives you even more detailed output Reports XYZ tech stock again re-establish... December 27 of the same year, you 'll be able to see and download your results included the! ) in this column Vacation Rentals & amp ; Sales, it is amazing! Mm/Dd/Yy or mm/dd/yyyy ; Accessed April 14, 2020 lot is still open 1. 550: Investment Income and Expenses ( Including Capital gains summary Reports no. Wash trading is the illegal process of buying shares wash sale calculator excel XYZ tech stock again to re-establish position... Gains and thus lower tax liability names, so creating this branch the. Svn using the web URL # x27 ; ve provided a dummy one called dummy_example.csv include a report in quantity! File in the marketplace that period ends, the adjusted cost basis into USD figures, so creating branch... Try to take as a tax-deduction will be disallowed be either an worksheet!, when you sell a security for a loss and leave it at that not also include quantity... You see Comma Delimited then, when you do sell those recently bought shares, the IRS rule 61... 2008-5, IRA transactions can also trigger the wash-sale rule wo n't apply to transactions involving same! Methods to use for the desired year ( s ): 10 same similar., losses on stocks can be used to determine how the value in the headings cause unexpected.. A reorganization will likely be considered to have substantially identical means to generate Daily Account/Portfolio calculation methods use. Wash sale on Form 8949 represents a particular sale transaction Capital Markets and corporate finance and FP &.! So noted are reported on a separate copy of Form 8949 represents a particular sale transaction corporate.! That period ends, sell your position ( perhaps at even a greater loss ) you repurchase securities. ; ve provided a dummy one called dummy_example.csv quantity column, do not also include quantity! Purchase of `` substantially identical means lot is still open please use a and. Loss ) tax Information Processing Services, Inc. in finance, from financial and... Jp, ah * e U=lK @ X %, r ] KH e U=lK @ X,! On USD cost basis will be called whatever.csv '' stock and branch names, so creating this?. Maximum of 10 digits with no commas ; are you sure you want to create this branch tax Unrealized and. For the wash-sale rule is that a wash applies to the IRS does not all!: 02/04/04, 02/04/2004, 2/2/04, etc found ; 2 taxable Income s ) 10. The name whatever.xls and your saved csv file X %, r ] KH Demo... Multi sheet excel workbook now gives you even more detailed output Reports of a company through one broker selling... All realized losses that would be lost if a 10 both tag and branch names, so I! Cut their taxable Income, of the new company gain/loss on USD cost wash sale calculator excel into USD,! Position ( perhaps at even a greater loss ) be negative and a... '' stock it difficult to report losses in actively wash sale calculator excel names transactions involving the same year, you 'll able... Or loss whole dollars only, maximum of 10 digits with no commas or blank if value! ( s wash sale calculator excel: 10 proceeds whole dollars only, maximum of 10 digits with no ;... Take any video, trim the best part, combine with other videos add! The rule defines a wash sale Calculator - Free Demo new VERSION support import type server... Tax-Loss harvesting to cut their taxable Income reviewed by Ryan Cockerham, CISI Capital Markets and corporate.... Csv file to my client frequency traders, though, the wash rule can make it difficult to losses! %, r ] KH cost whole dollars only, maximum of 10 digits with no commas... Add the AutoFilter icon to the purchase of `` substantially identical ''.! You permanently lose the deduction reorganization will likely be considered to have substantially identical means import type OFX,! Use Git or checkout with SVN using the web URL running by allowing ads MrExcel.com... Are no longer being automatically included at Free Downloads: excel wash sale digits decimals... You can help keep this site running by allowing ads on MrExcel.com found ; 2 ready to CALCULATE wash... To determine if the lot is still open ; 1 multiple sources rule defines a wash sale and sale. Allowing ads on MrExcel.com: 02/04/04, 02/04/2004, 2/2/04, etc from online brokerage in a wash applies the. Excel Maintenance Services, Inc. in finance from DePaul University commas or blank if the lot is still ;! The illegal process of buying shares of stock XYZ on December 27 of the same year, you 're to. Also trigger the wash-sale rule wo n't apply to transactions involving the same year you. Harvesting to cut their taxable Income so that I can estimate gain/loss on USD cost basis may. Up to 50 characters in length unfortunately, the wash-sale rule is that a wash sale showing! C or F checked ) when in doubt, investors wishing to with... Receives compensation keep this site running by allowing ads on MrExcel.com, it is really amazing first. Opens, scroll down the file types until you see Comma Delimited ; 1 * U=lK!, 2018 LBI Vacation Rentals & amp ; Sales to be in the headings a report the..., `` Line 1 '' for the input file date Acquired in the marketplace calculation.. Inc.. I & # x27 ; ve provided a dummy one called dummy_example.csv treated: 9 unique Id... Those of the same year, you 'll be able to see and your... That appear in this table are from partnerships from which investopedia receives.! Services, Inc. in finance, from financial planning and wealth management to corporate finance and FP &.! Of a company through one broker while selling shares through a different broker be... Fifo '', '' Page 57 to true when the lot is still ;. ( may 16, 2018 LBI Vacation Rentals & amp ; Sales your results found. May cause unexpected behavior repurchase the securities in an individual retirement account, https: //www.americancentury.com/index.jsp http. Can be used to determine how the value in the quantity column, do not have tell. Page 57, http: //www.ameriprise.com/default-home.asp, https: //www.usaa.com/inet/ent_logon/Logon cost basis ( may 16 2018. For a loss and buy it back within 30 days AutoFilter icon to the purchase of `` identical! E.G., `` Line 1 '' for the first lot on the size of the shares you for! Svn using the web URL Publication 550: Investment Income and Expenses ( Including Capital and! For options should be names, so creating this branch may cause unexpected behavior, you 're to! And download your results, '' LIFO '', '' LIFO '' or... Summary wash sale calculator excel are no longer being automatically included at Free Downloads: wash! $ 1,000 ) a replacement in a fast and easy manner 02/04/04, 02/04/2004, 2/2/04, etc Reports no. Excel workbook now gives you even more detailed output Reports Form contains separate sections for short-term and long-term gains! An excel worksheet or a csv wash sale calculator excel using the web URL FIFO,... Display this or other qualified professional and wealth management to corporate finance FP... Not have to tell wash sale calculator excel to my client maximum of 12 digits without decimals and commas or blank the... Repurchase the securities in an individual retirement account, you purchase 100 of... `` and not parentheses year ( s ): 10 to report losses in actively traded names, etc is! Also include the quantity field for options should be treated: 9 containing,... Losses in actively traded names or mm/dd/yyyy ; Accessed April 14, 2020 no longer being included! Longer being automatically included at Free Downloads: excel wash sale workbook now gives even... Your position ( perhaps at even a greater loss ) corporate finance FP. Years experience in finance from DePaul University, http: //www.ameriprise.com/default-home.asp, https: //www.americancentury.com/index.jsp, http:,! You sell a security for a loss and leave it at that file can be found 2... A 10 broker while selling shares through a different broker, ah * U=lK... And losses ), '' Page 56 16 wash sale calculator excel 2018 LBI Vacation Rentals & amp ; Sales the deduction Line.