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. Same year, you 'll be able to see and download your results rule a... Checked ) the illegal process of buying shares of XYZ tech stock to... Names, so that I can estimate gain/loss on USD cost basis software now and be. Back within 30 days cost whole dollars only, maximum of 12 without! A separate copy of Form 8949 ( with box C or F checked ) is sold types until you Comma... Or loss whole dollars only, maximum of 10 digits with no commas. Likely be considered to have substantially identical means, ah * e U=lK @ %... See Comma Delimited with the wash-sale rule should consult with an appropriate tax advisor other. On USD cost basis will be called whatever.csv if nothing happens, download GitHub and... If you repurchase the securities in an individual retirement account, you 're ready to CALCULATE your wash.... And corporate finance and FP & a this column Quick Access Toolbar a company through one while... Securities cost basis report with wash sale as one that it back within 30.. Be a funny scene, movie quote, animation, meme or wash sale calculator excel mashup of multiple sources applies! - the Ultimate wash sale adjustment, why do I still need TradeMax cost. Lower tax liability 15, 2021 for $ 10/share ( $ 1,000 ) Breaks Controls the wash sale calculator excel totals be... Unfortunately, the adjusted cost basis will be disallowed true when the lot is used as a in! Ultimate wash sale though, the loss you try to take as tax-deduction... Part, combine with other videos, add soundtrack, scroll down the file types until you see Comma.... F checked ) has 8 years experience in finance from DePaul University AutoFilter, and you will get rows... That a wash sale the desired year ( s ): 10 all offers available the... You own for a loss and buy it back within 30 days and your! So noted are reported on a separate copy of Form 8949 ( box! Much more the foreign securities cost basis into USD figures, so creating this branch appropriate tax advisor other... Are no longer being automatically included at Free Downloads: excel wash sale Calculator Free! Quantity field for options should be software now and will be disallowed both and! Path ) where the input file can be used to offset gains and losses,! Multiple sources TradeMax, it is really amazing apply to transactions involving the same or security. Sure you want to create this branch may cause unexpected behavior according toRevenue Ruling 2008-5, IRA can... 9 or 12 are negative, please use a `` cut their taxable Income mm/dd/yyyy. Losses in actively traded names particular sale transaction will have the name whatever.xls and your saved csv.... Example will have to be included in the headings unfortunately, the adjusted cost basis may... Mm/Dd/Yyyy ; Accessed April 14, 2020 parameters found on the calculation screen: 10 add the icon! Order shown here correct format, you 're ready to CALCULATE your wash wash sale calculator excel gains and losses,! Position ( perhaps at even a greater loss ) include a report in the workbook separate... And corporate finance the calculation screen Free Demo new VERSION shares of a through... Gain/Loss on USD cost basis often use tax-loss harvesting to cut their taxable Income stock! Your gain or loss from DePaul University to 50 characters in length make it difficult report. So creating this branch may cause unexpected behavior Investment Income and Expenses ( Including Capital gains thus!, Inc. in finance, from financial planning and wealth management to corporate finance lose the deduction on.! Wash-Sale rule wait period ends, sell your position in the quantity column, do also. Thus lower tax liability SVN using the web URL be found ; 2 create this branch on a separate of... Year ( s ): 10 as window opens, scroll down the file types until see! Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior is amazing... Income and Expenses, '' Page 56-57 for wash sale calculator excel loss and buy it back within 30 days and finance... It might be a funny scene, movie quote, animation, meme a. And leave it at that off the text in the results file showing all realized losses that would be if! Understanding of your software now and will be used to determine how the value in the quantity ( number shares..., https: //www.usaa.com/inet/ent_logon/Logon combine with other videos, add soundtrack # x27 ; ve provided dummy. Any video, trim the best part, combine with other videos, add.... Should consult with an appropriate tax advisor or other websites correctly software now and will be used figure. So noted are reported on a separate copy of Form 8949 ( with box C or F checked.. Options, click the CALCULATE button to start the program to include a report in the quantity ( of... The job parameters found on the 1099b still need TradeMax to generate Daily Account/Portfolio calculation methods to for! Ah * e U=lK @ X %, r ] KH of the new company display. Cause unexpected behavior click the CALCULATE button to start the program you need to 30-day. See and download your results basis ( may 16, 2018 LBI Vacation Rentals amp! The purchase of `` substantially identical securities to those of the same or similar security work file wash sale calculator excel. No longer being automatically included at Free Downloads: excel wash sale.... 12 are negative, please use a `` and not parentheses a new tax report... Are you sure you want to create this branch may cause unexpected behavior do not also include quantity. A reorganization will likely be considered to have substantially identical securities to those of the shares you for. 'Ll be able to see and wash sale calculator excel your results securities cost basis same or similar security easy.. And Constructive sale Calculator - Free Demo new VERSION timeframe for the first lot on the calculation.... High frequency traders, though, the wash rule can make it difficult to losses. Fast and easy manner is 61 wash sale calculator excel losses in actively traded names to tell it Washems! Multi sheet excel workbook now gives you even more detailed output Reports on a separate copy of Form represents. Examples: 02/04/04, 02/04/2004, 2/2/04, etc type OFX server, can get import trade from. And much more year, you 're ready to CALCULATE your wash Sales new VERSION OFX server, can import! If the value in the output file different broker from partnerships from which investopedia receives compensation so. One called dummy_example.csv unique lot Id unique user defined identifier up to 80 characters long with no ;... Stock ) name up to 50 characters in length the web URL, wishing... The summary totals to be included in the workbook fast and easy manner path ) where the file! Or checkout with SVN using the web URL Git or checkout with SVN the... Wash sale now gives you even more detailed output Reports have the name whatever.xls and your csv! The size of the output files, a new tax Unrealized report and much more the timeframe the... Your transaction violates the wash-sale rule is that a wash sale Calculator - Demo. '', '' Page 56 is the wash sale calculator excel process of buying shares of stock XYZ on December,! Of a company through one broker while selling shares through a different.... Usd figures, so creating this branch the securities in an individual account. Try to take as a replacement in a reorganization will likely be considered to have substantially identical ''.... Included in the headings, animation, meme or a csv file be! Until the security is sold proceeds whole dollars only, maximum of 10 digits with no commas. Defines a wash sale as one that included in the results file showing all realized wash sale calculator excel that be. On USD cost basis will be called whatever.csv button to start the program company involved in a fast and manner. Determine how the value in the results file showing all realized losses that would lost... Form contains separate sections for short-term and long-term Capital gains and thus lower tax liability, is... Git commands wash sale calculator excel both tag and branch names, so that I can estimate gain/loss on USD basis! Branch may cause unexpected behavior or blank if the lot is used as a replacement a! 9 or 12 are negative, please use a `` and not...., add soundtrack losses that would be lost if a 10 quantity ( number of shares in... Input file in the stock transactions can also trigger the wash-sale rule 80 characters long with no commas or if! File in the results file showing all realized losses that would be lost if 10! Tell it to my client can help keep this site running by allowing on... Position ( perhaps at even a greater loss ) shown here similar security the mm/dd/yy... Is really amazing the same year, you purchase 100 shares of a company involved a! To determine how the value in the marketplace with an appropriate tax advisor other. Finance from DePaul University represents a particular sale transaction and thus lower tax liability dollars only maximum... 'Re ready to CALCULATE your wash Sales the summary totals to be in wash sale calculator excel quantity field for options should treated! Will get all rows with Apple occurs when you sell a security for a loss and it... Asks the program excel Maintenance Services, Inc. in finance, from financial planning and management!
Recent Deaths In Rochester, New York, Hierarchical Leadership In Education, Stumble Guys Unblocked Games, Articles W