import csv
import pandas as pd
indexdf = pd.read_excel("F:\RockzFX Academy 2020\Trading\Intraday_Analysis\Index.xlsx",header=None)
indexdf.set_index(indexdf.iloc[:,0],inplace=True,drop=False)
day1 = pd.read_csv('F:\RockzFX Academy 2020\Trading\Intraday_Analysis\MW-SECURITIES-IN-F&O-13-Aug-2020.csv')
day2 = pd.read_csv('F:\RockzFX Academy 2020\Trading\Intraday_Analysis\MW-SECURITIES-IN-F&O-14-Aug-2020.csv')
pd.set_option("display.max_rows", None, "display.max_columns", None)
# REMOVING SPACE & NEXT LINE CHARACTER FROM THE COLUMN
day1.rename(columns={'SYMBOL \n': 'SYMBOL', 'HIGH \n': 'D1-HIGH', 'LOW \n':'D1-LOW', 'LTP \n':'D1-CLOSE', 'OPEN \n':'D1-OPEN'}, inplace=True)
day2.rename(columns={'SYMBOL \n': 'SYMBOL', 'HIGH \n': 'D2-HIGH', 'LOW \n':'D2-LOW', 'LTP \n':'D2-CLOSE', 'OPEN \n':'D2-OPEN'}, inplace=True)
# TAKING ONLY SYMBOL, HIGH, LOW, & LTP = CLOSE FOR ANALYSIS
day1 = day1[['SYMBOL', 'D1-OPEN', 'D1-HIGH', 'D1-LOW', 'D1-CLOSE']]
day2 = day2[['SYMBOL', 'D2-OPEN', 'D2-HIGH', 'D2-LOW', 'D2-CLOSE']]
day1['SYMBOL']=day1['SYMBOL']+"-EQ"
day2['SYMBOL']=day2['SYMBOL']+"-EQ"
#CHANGING INDEX OF DATAFRAME TO SYMBOL
day1.set_index('SYMBOL', inplace=True, drop=False)
day2.set_index('SYMBOL', inplace=True, drop=False)
day1=day1.reindex(indexdf.index)
day2=day2.reindex(indexdf.index)
#Removing "," from the string
day1 = day1.replace(',','', regex=True)
day2 = day2.replace(',','', regex=True)
def rangetrendAnalysis(df1):
if (df1['D1-OPEN'] > df1['D1-CLOSE']):
return "Bearish"
elif (df1['D1-OPEN'] < df1 ['D1-CLOSE']):
return "Bullish"
nextDaydf['Result'] = rangetrendAnalysis(day1)
print (nextDaydf.head)
Error:
runfile('F:/RockzFX Academy 2020/Trading/Intraday_Analysis/topost.py', wdir='F:/RockzFX Academy 2020/Trading/Intraday_Analysis')
Traceback (most recent call last):
File "<ipython-input-6-c5b5b2e300c8>", line 1, in <module>
runfile('F:/RockzFX Academy 2020/Trading/Intraday_Analysis/topost.py', wdir='F:/RockzFX Academy 2020/Trading/Intraday_Analysis')
File "C:\Users\REJO-HOME\Anaconda3\lib\site-packages\spyder_kernels\customize\spydercustomize.py", line 827, in runfile
execfile(filename, namespace)
File "C:\Users\REJO-HOME\Anaconda3\lib\site-packages\spyder_kernels\customize\spydercustomize.py", line 110, in execfile
exec(compile(f.read(), filename, 'exec'), namespace)
File "F:/RockzFX Academy 2020/Trading/Intraday_Analysis/topost.py", line 52, in <module>
nextDaydf['Result'] = rangetrendAnalysis(day1)
File "F:/RockzFX Academy 2020/Trading/Intraday_Analysis/topost.py", line 46, in rangetrendAnalysis
if (df1['D1-OPEN'] > df1['D1-CLOSE']):
File "C:\Users\REJO-HOME\Anaconda3\lib\site-packages\pandas\core\generic.py", line 1478, in __nonzero__
.format(self.__class__.__name__))
ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().