Freefor a limited time: World's most 'complete' GRE Course ($250 value) | Click here to know more and register!

INQUIRE
INQUIRE

=TEXT(DateCell,"dddd")

The analysis of Bank Nifty historical data in Excel can be extended in various ways. For example, one can use machine learning algorithms to predict future prices of Bank Nifty or use technical indicators to identify trading signals. Additionally, one can use Excel to analyze other financial data such as stock prices, currency exchange rates, or commodity prices.

In a new column, she calculated daily close-to-close returns:

Covered by…