Read the Beforeitsnews.com story here. Advertise at Before It's News here.
Profile image
By Political Calculations (Reporter)
Contributor profile | More stories
Story Views
Now:
Last hour:
Last 24 hours:
Total:

Microsoft Excel and the S&P 500

% of readers think this story is Fact. Add your two cents.


Microsoft Excel is a spreadsheet application that was first launched for Apple’s MacIntosh computers in 1985 and for personal computers running Microsoft’s Windows 2.0 operating system in November 1987.

Separately, we learned from a note tucked in the July 2019 edition of the S&P 500 Market Attributes spreadsheet that its author, Howard Silverblatt, is now in his forty-third year of working at Standard and Poor, where he oversees all the data related to the S&P 500 stock market index.

The S&P 500 itself has been around since 1957, while its predecessor index, the S&P 90, goes back at least to December 1925. Its component stocks have data available that go back even further in time, where we can extend the historical reach of the stocks that made up the S&P 90 and later the S&P 500 all the way back to January 1871.

Which brings us to the S&P 500 Earnings and Estimates spreadsheet, which is also authored by Howard Silverblatt, whose data covering the history of the S&P 500 begins with March 1988, the month ending 1988-Q1.

With so much history, we always wondered why the data provided by S&P for its signature stock market index only went back to March 1988. It wasn’t until we learned the history of Microsoft Excel that we finally put two and two together and it all finally made sense. That quarter was likely when Howard started using Excel to analyze the S&P 500!

To mark that realization, and Howard’s 43rd year at S&P, we’ve used the data from that spreadsheet to visualize the quarterly history of the S&p 500 index, from 1988-Q1 through 2019-Q2, covering the index’ value, its divisor (the rough equivalent of the number of shares of a regular stock), and its market capitalization, where we multiplied the S&P 500′s value by its divisor to generate its market cap history, which is something that Microsoft Excel happens to make easy to do!

How much other, older data is still out there unexplored because it was documented using applications that have been lost to time?


Source: https://politicalcalculations.blogspot.com/2019/08/microsoft-excel-and-s-500.html


Before It’s News® is a community of individuals who report on what’s going on around them, from all around the world.

Anyone can join.
Anyone can contribute.
Anyone can become informed about their world.

"United We Stand" Click Here To Create Your Personal Citizen Journalist Account Today, Be Sure To Invite Your Friends.

Please Help Support BeforeitsNews by trying our Natural Health Products below!


Order by Phone at 888-809-8385 or online at https://mitocopper.com M - F 9am to 5pm EST

Order by Phone at 866-388-7003 or online at https://www.herbanomic.com M - F 9am to 5pm EST

Order by Phone at 866-388-7003 or online at https://www.herbanomics.com M - F 9am to 5pm EST


Humic & Fulvic Trace Minerals Complex - Nature's most important supplement! Vivid Dreams again!

HNEX HydroNano EXtracellular Water - Improve immune system health and reduce inflammation.

Ultimate Clinical Potency Curcumin - Natural pain relief, reduce inflammation and so much more.

MitoCopper - Bioavailable Copper destroys pathogens and gives you more energy. (See Blood Video)

Oxy Powder - Natural Colon Cleanser!  Cleans out toxic buildup with oxygen!

Nascent Iodine - Promotes detoxification, mental focus and thyroid health.

Smart Meter Cover -  Reduces Smart Meter radiation by 96%! (See Video).

Report abuse

    Comments

    Your Comments
    Question   Razz  Sad   Evil  Exclaim  Smile  Redface  Biggrin  Surprised  Eek   Confused   Cool  LOL   Mad   Twisted  Rolleyes   Wink  Idea  Arrow  Neutral  Cry   Mr. Green

    Total 1 comment
    MOST RECENT
    Load more ...

    SignUp

    Login

    Newsletter

    Email this story
    Email this story

    If you really want to ban this commenter, please write down the reason:

    If you really want to disable all recommended stories, click on OK button. After that, you will be redirect to your options page.