Skip to content

Opening book details…

Can I read Convert Trading Days to Calendar Days on EtoBox?

Convert Trading Days to Calendar Days by turtlespiritflutes is a document available to read on EtoBox.

What is Convert Trading Days to Calendar Days about?

This document provides steps to convert trading day data to calendar day data in Excel. It involves: 1) Copying the trading day data and adding calendar days below by copying a formula that increments dates. 2) Converting the calendar day formulas to values to prevent accidental changes. 3) Removing duplicate dates while keeping the calendar days at the bottom to avoid deleting trading data. 4) Sorting the combined column of trading and calendar days to insert weekends and holidays.

Author
turtlespiritflutes
Language
EN