/********************************************************************************************************************/
/* Newsletter: State Of The Stock Market v1.0	README																*/
/********************************************************************************************************************/

/* This Program will automatically download the current closing value of the S&P 500, determine wheter the economy has improved or not that day, create a graphic in excel
and format all the information to be sent in a newsletter utilizing Outlook. */

/* Please keep in mind that the Program should be preconfigured to function properly. */
/* All related files are stored in C:\users\public\ and are created after running the Program the first time. */

/* Mails.txt stores all e-mail adresses, feel free to copy the desired participants in, giving each a seperate line or use the Program to add them */
/* If adding is done manually, please make sure that the last line in the txt file is an empty one, so after the last e-mail hit enter. */
/* For the Program to work, you need to be logged into an e-mail account in Outlook, which should be opened in the background. */

/* data.csv gets downloaded and overwritten every time the Program is run, data is retrieved from from Yahoo Finance */

/* Main.xlsx is used to create the graph and store S&P 500 Values, Yahoo Finance only allows to retrieve a single value, therefore before starting the program for the first time,
it is highly recommended to fill A1 to A19 by hand, simply choose the S&P 500 closing values for the last 20 days. 
Afterwards a new value is added each day and the oldest deleted, the program operates fully autonomous. If this is not done, random values for those cells are created! */

/* The historical stock data is saved as C:\users\public\pic.jpg */

/* Excel operations are executed invisibly (excel will be closed after its no longer needed). */

/* Thanks to https://www.asciiart.eu for the textart at the beginning of the program. */