Name: 400k NYSE Random Investments + Financial Ratios
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

400k NYSE Random Investments + Financial Ratios

Context

This dataset was created to make the project "AI Learn to invest" for SaturdaysAI - Euskadi 1st edition. The project can be found in https://github.com/ImanolR87/AI-Learn-to-invest

Content

More than 400.000 random investments were created with the data from the last 10 years from the NYSE market. Finantial ratios and volatilities were calculated and added to the random investments dataset.

Finantial ratios included:

ESG Ranking
ROA
ROE
Net Yearly Income
PB
PE
PS
EPS
Sharpe

Acknowledgements

I thank SaturdaysAI to push me falling in love with data science.

Inspiration

Our inspiration was to find an answer to why young people doesn't invest more on Stock-Exchange markets.

Tables

Final Transactions Dataset

@kaggle.imanolrecioerquicia_400k_nyse_random_investments_finan_71591dae.final_transactions_dataset

17.68 MB
405,258 rows
25 columns

CREATE TABLE final_transactions_dataset (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "company" VARCHAR,
  "sector" VARCHAR,
  "horizon_days" BIGINT  -- Horizon (days),
  "amount" BIGINT,
  "date_buy_fix" TIMESTAMP,
  "date_sell_fix" TIMESTAMP,
  "price_buy" DOUBLE,
  "price_sell" DOUBLE,
  "volatility_buy" DOUBLE,
  "volatility_sell" DOUBLE,
  "sharpe_ratio" DOUBLE,
  "expected_return_yearly" DOUBLE  -- Expected Return (yearly),
  "inflation" DOUBLE,
  "nominal_return" DOUBLE,
  "investment" VARCHAR,
  "esg_ranking" DOUBLE,
  "pe_ratio" DOUBLE,
  "eps_ratio" DOUBLE,
  "ps_ratio" DOUBLE,
  "pb_ratio" DOUBLE,
  "netprofitmargin_ratio" DOUBLE,
  "current_ratio" DOUBLE,
  "roa_ratio" DOUBLE,
  "roe_ratio" DOUBLE
);