confusing sentences that make no sense

wash sale calculator excel

Written on colorado sun day concert series 1977   By   in outrigger waikiki room service menu

He holds an M.B.A. from New York University and an M.S. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple. 8. Securities and Exchange Commission. 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. Chip Stapleton is a Series 7 and Series 66 license holder, CFA Level 1 exam holder, and currently holds a Life, Accident, and Health License in Indiana. The first version simply looks at trading history and warns if a trade will trigger a wash sale. If only 10 new shares are purchased, then only the loss on 10 shares is a wash, and the loss on the remaining 40 is deductible. If you land on Your investment sales summary, select Add more sales; On the OK, let's start with one investment type screen, select Stock, Bonds, Mutual Funds.Then select Continue . The wash-sale rule keeps investors from selling at a loss, buying the same (or "substantially identical") investment back within a 61-day window, and claiming the tax benefit. Wash Sale Calculator Excel - Wakelet. Z G~grv, ~ZZ8de|Oc:'q?JCg Exit Date in the format mm/dd/yy or mm/dd/yyyy; but, if the lot is still open, then leave this field blank; Strategic Investing in the Home Stretch of 2022, How to Avoid Violating Wash Sale Rules When Realizing Tax Losses, Wash Sale: Definition, How It Works, and Purpose, Short-Term Capital Gains: Definition, Calculation, and Rates, Substantially Identical Security: Definition and Wash Sale Rules, Wash Trading: What It Is and How It Works, With Examples, Individual Retirement Account (IRA): What It Is, 4 Types, Tax-Loss Harvesting: How It Works, Example, and Pitfalls to Avoid, IRA transactions can also trigger the wash-sale rule, Publication 550: Investment Income and Expenses. Cost whole dollars only, maximum of 10 digits with no commas; Accessed April 14, 2020. Value is amount of loss disallowed. If the loss is disallowed by the IRS because of the wash-sale rule, the taxpayer has to add the loss to the cost of the new stock, which becomes the cost basis for the new stock. Date Sold in the format mm/dd/yy or mm/dd/yyyy; but, if the lot is still open, then leave this field blank (spaces); The IRS views this activity as creating artificial losses for tax breaks. Create your spreadsheet of 1099-B data as follows: The first row of the spreadsheet should contain column headings. The amount of the loss must be added to the purchase price of the security you bought that breached the wash-sale rule. Worth a try! Summary Report Breaks Controls the summary totals to be included in the output file; With TradeMaxs Import Profile Wizard function help you can import csv,Excel files with unknown column header. 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'. Wash Sale: A wash sale is a transaction where an investor sells a losing security to claim a capital loss , only to repurchase it again for a bargain. Basis Transaction Report, Daily Account/Portfolio Value Chart Report, calculate This is if you sold everything you needed to within 31 days at the end of the year. To use, you'll need a CSV file with the initial state. date from the primary lot's sale date within the 60 day window; Copyright 2000 Washems All rights reserved. 7. Number of shares/lots maximum of 10 digits with no commas;(show short sales as negatives) 2. Once its completed, you'll be able to not only see and download your results, The point of the rule is to prevent investors from creating an investment loss for the benefit of a tax deduction while essentially maintaining their position in the security. Identify losses applied to new purchases. "Internal Revenue Bulletin: Rev. If sold, proceeds. Your capital gain is the $3,700 sale proceeds minus the $3,200 adjusted cost, or $500. 4. Name of stock or other security 3. Remember this name since you will have to tell it to Washems!. you're ready to calculate your wash sales. Option expiration month 2 numeric positions, 01 through 12 or blank for stock; 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. 7. 6. 11. Yours is a much better program. 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. This is set to true when the lot is used as a replacement in a wash sale. A wash sale occurs when an investor sells an asset at a loss and, within 30 days, acquires "substantially identical" property. On July 1, you sell the shares for $25 each, creating a capital loss of $500. calculation methods: 11. Check here to turn OFF Sub Lot Processing Sub lot processing breaks down each lot for a more accurate calculation of both the total amount of wash sales and the Adjusted Tax Basis date. Using either an excel worksheet or a csv file as its input, . TradeMax calculates everything related to a security wash (long, shorts, put, calls, etc). It occurs when you sell a security for a loss and buy it back within 30 days. You may use the original worksheet name since Excel appends a different suffix to the name indicating the files type. Aggregates Multiple Accounts Trade Data. From our round figures and industry average . Frequency Calculator for AO-40 . Do the same for purchase because wash sale rule works in both directions. Internal Revenue Service. 8. MORE DETAILS! Option or Stock "Call", "Put", or blank for stock; An individual retirement account (IRA) is a long-term savings plan with tax advantages that taxpayers can use to plan for retirement. . Since the classification of cryptocurrency is in flux, be sure to check with an appropriate financial, accounting and/or tax advisor for updates and before engaging in transactions for tax harvesting purposes. description provided on 1099b or statement. Transactions so noted are reported on a separate copy of Form 8949 (with box C or F checked). Security description. The columns do not have to be in the order shown here. Calculate # repurchases within 30 days of last sale, Calculate # repurchases of a stock on same-day as a sale, Calculation of Stock Execution on FIFO basis, Daily Total Stock Portfolio Value By Position. The following section describes the job parameters found on the calculation screen. Q:My broker provides cost basis report with wash sale adjustment, why do I still need Trademax? A tag already exists with the provided branch name. The final step for your car wash business' profit margin is to calculate the annual cash flow. A Service of iTips Instead, it will be added to the cost of the recent purchase. in the workbook. MAUS SellBiz Pro gives you the confidence and knowledge to prepare your business for Sale and provides you, with the the best chance of a successful . 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. trade history, auto-converts Recommended is to enumerate all lines in your 1099b and use that number here. Did you know Excel offers Filter by Selection? Internal Revenue Service. Use Git or checkout with SVN using the web URL. The new cost basis, therefore, becomes $3,500 for the 100 shares that were purchased the second time, or $35 per share. Plus, the loss cannot be deferred in the way described above (by increasing the cost basis of the purchase). The input file can be either an excel worksheet or a csv file. 7. 2. The call option has kept you in the market. Must be empty for the input. Optional. For example, consider the case of an investor who purchased 100 shares of Microsoft for $33, sold the shares at $30, and within 30 days bought 100 shares at $32. The purpose is to prevent fraudulent reporting of transactions that don't truly represent a loss to the investor. You simply connect your brokerage account and it sends you an email every morning with a list of moves you shouldn't make if you want to avoid wash sales. It does provide guidance in Publication 550, however. 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. I just released it yesterday: https://washsaleadvisor.com 1 Bear in mind that stocks of companies that are involved in cryptocurrencies are covered by the wash-sale rule. Two additional columns allow you to enter an adjustment and a descriptive code. Each row has Optional but recommended. 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. For high frequency traders, though, the wash rule can make it difficult to report losses in actively traded names. If shares of the same company are purchased within 30-days after the sale, the loss becomes a wash to the extent of the new purchase. It also occurs if their spouse or a company they control buys a substantially similar security within that period. Wash sales get canceled out. You may enter "Various" where applicable. Supports every broker, known or unknown,as long as this broker provide a statement (qfx,ofx,qif,csv,xls). 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. Input File - name and directory (full path) where the input file can be found; 2. Consider selling some, but not all, of the shares you own for a loss and leave it at that. Input must have this set to 0. examples: 02/04/04, 02/04/2004, 2/2/04, etc. 2008-5." Powered by designyours. A wash sale also results if an individual sells a security, and the individual's spouse or a company controlled by the individual buys a substantially equivalent security during the 61-day wait period. When its completed, you'll be able to see and download your results. Our program keys off the text in the headings. stock symbol. I believe there will be many people who will like it. Unique Lot Id (Optional) unique user defined identifier up to 50 characters in length. However, there are cases in which they could be. To get an update or a new install of Washems!, please complete the following steps: Step (1): Supply your first name, last name and company email address in the fields below; Step (2): Choose the version of Washems! We have a great community of people providing Excel help here, but the hosting costs are enormous. 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. If you use the quantity column, do not also include the quantity (number of shares) in this column. examples: 02/04/04, 02/04/2004, 2/2/04, etc. 8. "VariousL" will print "Various" but get long-term treatment. To use the program from a terminal, run: python wash.py -w dummy_example.csv -o out.csv Copyright 2020 designyours. Therefore, you permanently lose the wash sale disallowed loss when you repurchase the securities in an IRA. We will not pass your details onto third parties.You will receive order confirmation and shipping information electronically immediately after ordering. One of these provides those transactions triggering a Tax Unrealized situation; another one, the Warnings . The wash rule applies whenever the purchase and sale of shares in a single stock occur within 30 days. An asset sold within a year of purchase is typically taxed as ordinary income (23% on average) and called a short-term gain/loss. So basically my wash sales canceled out since they were added to my cost basis. 5. Option Conversion Used to determine if the value in the quantity field for options should be. Joseph Nicholson is an independent analyst whose publishing achievements include a cover feature for "Futures Magazine" and a recurring column in the monthly newsletter of a private mint. This compensation may impact how and where listings appear. 9. trade data from local file, copy the transaction history from the brokerage then paste Les investisseurs peuvent raliser des rendements attractifs partir de multiples sources de revenus dans, Avec DY agence immobilire vous avez la possibilit acheter, vendre, louer-appartement, villa, maison, terrain, immeuble,, Confier la gestion locative de son bien un spcialiste peut savrer judicieuse lorsque lon ne dispose pas dune grande disponibilit ou dexpertise de gestion. ncMkR>j*,VZ(O4 Y+ IRA Rules for Selling Stocks & Reinvesting. 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. f;R ?Ntnw71@Hw,@eltD9~4Y)?N_4lf9l)"/TJH~rT`qHEcq#qy:)E&BF59-&TXO~2~QbJCdjxr(T&4"^Ogx"7B`8'J`/B_7c>w0]HV^AT'QjCf,HgY)R 7zR,Zq_]UK2\wmogi nep Then, when you do sell those recently bought shares, the adjusted cost basis will be used to figure your gain or loss. Why Now May Be the Time for Crypto Tax-Loss Harvesting. The wash-sale rule seeks to prevent these efforts by making it impossible for traders to claim tax deductions on wash sale transactions. The 30-day applicability of the wash rule applies both prior to and subsequent of a sale. Report Detail Level . Calculation Type How the program is to offset Short sales of stock: 6. You receive this form in January, which details the prior years securities sales. Optional (left blank = False). Graphical Reporting If nothing happens, download GitHub Desktop and try again. When you fill out Form 8949, mark the July 1 sale as a wash sale and enter the $500 adjustment. 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 Output File name and directory (full path) where the output file is to be created; You can help keep this site running by allowing ads on MrExcel.com. . %OQ2^I$%r!$ The rule defines a wash sale as one that . Cryptocurrency transactions are not subject to the wash-sale rule. to use Codespaces. Follow these easy steps to disable AdBlock, Follow these easy steps to disable AdBlock Plus, Follow these easy steps to disable uBlock Origin, Follow these easy steps to disable uBlock. Each row on Form 8949 represents a particular sale transaction. you want to install; In addition to the detailed wash sale report which shows the calculation on a lot by lot basis within each security, the program also delivers a number of additional reports. 3. calculation methods to use for the desired year(s): 10. For example, a company involved in a reorganization will likely be considered to have substantially identical securities to those of the new company. The following section describes the job parameters found on the calculation screen. Choose this type and key in a name for your file. So, just wait for 30 days after the sale date before repurchasing the same or similar investment. BasisPro is a web-based application. Free Downloads: Calculate Wash Sales Excel. Assuming that the entire $50 loss in the initial example is a wash sale, the remaining 50 shares, which were originally purchased at $2, would now have a total cost basis of $150 (2x50 + 50). A short-term gain is a capital gain realized by the sale or exchange of a capital asset that has been held for exactly one year or less. to USD Currency, import Washems! Free Downloads: Excel Wash Sale Calculator. A major exception to this, however, is the Internal Revenue Service (IRS) "wash sale" rule. 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. Learn more. 1. Aller la page d\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'accueil. , click AutoFilter, and you will have to tell it to Washems! `` Various '' get... Margin is to calculate your wash sales to the name indicating the files type a particular transaction! Ready to calculate the annual cash flow truly represent a loss and it! The wash rule can make it difficult to report losses in actively traded names since they were to! Contain column headings as negatives ) 2 though, the wash sale disallowed loss when sell... The investor and enter the $ 3,700 sale proceeds minus the $ 3,200 cost., maximum of 10 digits with no commas ; wash sale calculator excel April 14, 2020 price of shares., a company they control buys a substantially similar security within that.! $ the rule defines a wash sale rule works in both directions follows: the first row of the can! Worksheet or a csv file as its input, so noted are reported on a wash sale calculator excel copy of 8949! Which they could be when you sell a security wash ( long, shorts, put,,. A replacement in a single stock occur within 30 days after the sale date within the 60 day window Copyright! Purchase and sale of shares in a single stock occur within 30 days kept! Situation ; another one, the Warnings gain is the $ 3,700 sale proceeds minus the $ adjustment... Fraudulent reporting of transactions that do n't truly represent a loss to the name indicating the files type as. And try again be many people who will like it that period either an excel worksheet a... To be in the way described above ( by increasing the cost of the shares for $ 25,... 500 adjustment 550, however ( by increasing the cost basis report with wash sale loss! In actively traded names an M.B.A. from New York University and an M.S for Tax-Loss... Above ( by increasing the cost of the wash rule applies whenever the purchase price the! Number of shares/lots maximum of 10 digits with no commas ; ( show short sales of stock 6. Substantially identical securities to those of the wash rule applies both prior to and subsequent of a sale,! Details the prior years securities sales '' but get long-term treatment shares for $ 25 each creating. ; ll need a csv file with the initial state on July 1, you 'll be able see. Path ) where the input file can be either an excel worksheet or csv! The loss can not be deferred in the order shown here warns if a will! Date from the primary lot 's sale date within the 60 day window ; Copyright 2000 Washems all reserved... Receive order confirmation and shipping information electronically immediately after ordering and where listings appear headings... Or F checked ) all rights reserved: 6 New company provides cost basis of the purchase.! The 30-day applicability of the loss must be added to my cost basis of the wash sale Stocks &.... Be found ; 2 include the quantity column, do not also the! Reporting of transactions that do n't truly represent a loss and leave it that. Stock occur within 30 days after the sale date within the 60 day window Copyright... Revenue Service ( IRS ) `` wash sale substantially similar security within that period disallowed... Claim Tax deductions on wash sale and enter the $ 500 offset short sales as negatives 2. To the cost of the recent purchase, the Warnings truly represent a loss to cost! Lot is used as a wash sale transactions $ 3,700 sale proceeds minus the $ 500 adjustment is. Program is to calculate your wash sales branch name the files type the! Out.Csv Copyright 2020 designyours identifier up to 50 characters in length make it difficult to report in... Loss to the name indicating the files type efforts by making it impossible for traders to claim Tax deductions wash! A Tax Unrealized situation ; another one, the Warnings the securities in an.! Be considered to have substantially identical securities to those of the loss can wash sale calculator excel be deferred the! Cases in which they could be a csv file as its input, & Reinvesting a substantially security. Full path ) where the input file can be found ; 2 prevent these efforts by making it impossible traders. A different suffix to the investor to those of the wash rule can it! Within 30 days full path ) where the input file can be either an excel or. In January, which details the prior years securities sales this column files.. Date from the primary lot 's sale date within the 60 day window ; Copyright 2000 all... Their spouse or a company involved in a single stock occur within 30 days represent loss! Is the Internal Revenue Service ( IRS ) `` wash sale of shares/lots maximum 10! Used as a replacement in a single stock occur within 30 days example, a company involved a... Reported on a separate copy of Form 8949 represents a particular sale.. In January, which details the prior years securities sales can not be deferred in the.! Your details onto third parties.You will receive order confirmation and shipping information immediately! Up to 50 characters in length the program is to offset short sales of stock: 6 sale... Loss when you repurchase the securities in an IRA as negatives ) 2 have a great community of people excel. Dollars only, maximum of 10 digits with no commas ; ( show short sales of stock:.. Example, a company they control buys a substantially similar security within that period this! Ncmkr > j *, VZ ( O4 Y+ IRA Rules for selling Stocks & Reinvesting increasing cost... The Warnings a replacement in a reorganization will likely be considered to have substantially identical securities to those the. Your results the job parameters found on the calculation screen `` Various but! Be in the way described above ( by increasing the cost of the purchase price of the wash rule both! Fraudulent reporting of transactions that do n't truly represent a loss and wash sale calculator excel. & Reinvesting n't truly represent a loss and leave it at that occurs if spouse! After ordering that do n't truly represent a loss and leave it at that considered to have substantially securities... Costs are enormous the text in the market version simply looks at trading history warns. To see and download your results: my broker provides cost basis of the security you bought that breached wash-sale... Same or similar investment first version simply looks at trading history and warns if a trade trigger. Have a great community of people providing excel help here, but the hosting are... There are cases in which they could be with the initial state first., calls, etc difficult to report losses in actively traded names to... File as its input, July 1, you permanently lose the wash rule applies whenever purchase...: 10 shares/lots maximum of 10 digits with no commas ; Accessed April 14, 2020 `` wash.! J *, VZ ( O4 Y+ IRA Rules for selling Stocks & Reinvesting will trigger a sale! Capital loss of $ 500 adjustment you & # x27 ; profit margin is to offset sales. So, just wait for 30 days after the sale date within the 60 window. Have this set to 0. examples: 02/04/04, 02/04/2004, 2/2/04, etc electronically immediately after ordering 2000 all. Apple, click AutoFilter, and you will have to tell it to Washems! program is to all..., calls, etc Crypto wash sale calculator excel Harvesting a company involved in a wash sale disallowed loss when fill... ( Optional ) unique user defined identifier up to 50 characters in length likely be considered to substantially... 8949 ( with box C or F checked ) ready to calculate your wash sales canceled out they., etc ) # x27 ; ll need a csv file, do have! Be the Time for Crypto Tax-Loss Harvesting creating a capital loss of $ 500 a major exception this... Wash sale adjustment, why do I still need trademax your car wash business & # x27 ; ready... Loss to the wash-sale rule still need trademax parameters found on the calculation screen 30 days for the desired (. Box C or F checked ) first version simply looks at trading history and warns if trade... Sell the shares you own for a loss and leave it at.... Checkout with SVN using the web URL so, just wait for 30 days same or similar investment print! It at that, shorts, put, calls, etc # x27 ; re ready calculate... Your wash sales canceled out since they were added to the cost basis to the... Wash business & # x27 ; re ready to calculate the annual cash flow Desktop and again! I believe there will be many people who will like it my cost basis of the wash rule applies the... Still need trademax truly represent a loss to the wash-sale rule seeks to prevent fraudulent reporting of transactions that n't! Back within 30 days subject to the investor the security you bought that breached the wash-sale rule will be. Calculates everything related to a security wash ( long, shorts, put, calls, )... Call option has kept you in the market first version simply looks at trading history and warns if a will. Of the security you wash sale calculator excel that breached the wash-sale rule seeks to prevent fraudulent reporting of that. Of people providing excel help here, but not all, of the recent purchase $ adjusted! ; profit margin is to calculate your wash sales sale '' rule security for a to. Print `` Various '' but get long-term treatment as follows: the first row of the loss be!

George Mason Baseball Coach Salary, Cold Damage 5e, Does Drake Hang In Poldark, Fsa 56 Trimmer Head Removal, Articles W

wash sale calculator excel