Use trendet library with investiny historical data

[alvarobartt]

Use trendet library with investiny historical data

[alvarobartt]

Hi, @AyseTheArk the date column has been included in the latest investiny release, so make sure to upgrade it as pip install investiny --upgrade and check that the installed version is 0.4.0! 😄

[alvarobartt]

Hi @AyseTheArk so trendet was developed more than 2 years ago and I've not checked it since then, but note that it was developed using investpy so it's prepared to use its data, whose output was a pandas.DataFrame while investiny.historical_data is returning a Python dictionary. If you manage to load it as a pandas.DataFrame keep in mind that the "date" column needs to be renamed to "Date" and set as the index, while all the other columns need to be renamed to "Open", "High", "Low", and "Close", respectively.

[AyseTheArk]

@alvarobartt But the data does not have a 'date' column:

Also to use the code in https://github.com/alvarobartt/trendet the data seem to need more columns such as 'Up Trend', as these lines for example:

labels = df['Up Trend'].dropna().unique().tolist()

for label in labels:
    sns.lineplot(x=df[df['Up Trend'] == label].index,
                 y=df[df['Up Trend'] == label]['Close'],
                 color='green')

    ax.axvspan(df[df['Up Trend'] == label].index[0],
               df[df['Up Trend'] == label].index[-1],
               alpha=0.2,
               color='green')

use df['Up Trend'], while df is created like this:

df = trendet.identify_all_trends(stock='BBVA',
                                 country='Spain',
                                 from_date='01/01/2018',
                                 to_date='01/01/2019',
                                 window_size=5,
                                 identify='both')

which gave me the error code investpy function call failed with Exception: ERR#0015: error 403, try again later.!. So the problem was in creating the right data for the code on https://github.com/alvarobartt/trendet and the investiny.historical_data doesn't seem to be the right data for this. Is there an alternative data to use the trendet library?

[AyseTheArk]

Hi, @alvarobartt is that then the data I need for the df in the code on https://github.com/alvarobartt/trendet ?