def to_csv(self, filename: str):
"""Exports the generated table into a CSV file.
Returns a CSV string if filename is None.
:param filename: CSV file path
:type filename: str
"""
if filename and filename.endswith(".csv"):
filename = filename[:-4]
if len(self.analysis) > 0:
export_to_csv(
[
"ticker",
"date",
"category",
"analyst",
"rating",
"price_from",
"price_to",
],
self.analysis,
f"{filename}-analysts.csv",
)
return export_to_csv(self.headers, self.data, f"{filename}.csv")
def to_google_csv(self, folder, csvMainName):
""" Exports the generated table into a CSV file, located in the user's current directory. """
self.headers.append('Current Price')
self.headers.append('Current Price Difference')
firstRow = 2
for data in self.data:
ticker = (data['Ticker'])
data['Current Price'] = "=GOOGLEFINANCE(\"" + ticker + "\")"
data['Current Price Difference'] = "=I" + str(
firstRow) + "-L" + str(firstRow)
firstRow += 1
export_to_csv(folder, csvMainName, self.headers, self.data)
def to_csv(self, filename: str):
""" Exports the generated table into a CSV file.
Returns a CSV string if filename is None.
:param filename: CSV file path
:type filename: str
"""
if filename and filename.endswith('.csv'):
filename = filename[:-4]
if len(self.analysis) > 0:
export_to_csv(['ticker', 'date', 'category', 'analyst', 'rating', 'price_from', 'price_to'],
self.analysis, f"{filename}-analysts.csv")
return export_to_csv(self.headers, self.data, f"{filename}.csv")
def to_csv(self, filename=None):
""" Exports the generated table into a CSV file.
Returns a CSV string if filename is None.
:param filename: CSV file path
:type filename: str
"""
return export_to_csv(self.headers, self.data, filename)
def to_csv(self):
""" Exports the generated table into a CSV file, located in the user's current directory. """
export_to_csv(self.headers, self.data)
