Convert an excel workbook to a php webpage.

  • Stav: Closed
  • Odměna: $500
  • Přijatých návrhů: 3
  • Vítěz: sblancovilchez

Instrukce k soutěži

I need to have the attached Excel workbook with all of its sheets converted to a PHP/JavaScript webpage; note that there are six sheets in this workbook.

The first year on the "User Interface" page needs to be variable, but it must at least go back to the year 2007.
The last year should automatically update to the last complete calendar year (e.g. as of today, 2017).

The "YOUR INVESTMENT" string should variable allowing the user to input a name.

On the User Interface tab, we need to ask the question: "Is your investment a private security?" With a Yes/No option to answer. If the answer is Yes, then the output from the Calculations sheet under "For Private Securities" replaces the appropriate outputs : "Eλ(Ri)" for "E(Ri)" and "αλ" for "α".

Every year's "Annual Return" (the blue cells) must be required fields. The S&P 500 and MSCI US REIT "Annual Returns" should be scraped. All calculations must update accordingly.

The layout of the webpage should be similar to the layout of the Excel workbook, but all the information in all the sheets in the Excel workbook should be accessible or display on one webpage.

Once you are familiar with workbook and have identified the user inputs, you can unlock the sheets to see the formulas with the password "physics".

On the Glossary sheet, the term "Private Securities" should be added after "Omega Ratio" and before "R-Squared". The definition for Private Securities is: "Securities are exempt from registration with the U.S. Securities & Exchange Commission ("SEC") and do not trade on a secondary exchange. As a result, private securities are illiquid, and the owner should expect to hold them for the term defined in their respective offering documents."

For the Current Market Data, I only need the current 10 yr treasury yield, and it can be scraped from https://www.marketwatch.com/investing/bond/tmubmusd10y?countrycode=bx
You'll need to change the label of the Risk Free Rate label on each sheet/tab from 5 yr to 10 yr.

Make user access to the page require login credentials that I can manage as an admin.

Doporučené dovednosti

Zpětná vazba od zaměstnavatele

“Santiago is extremely competent and eager to provide quality.”

Profilový obrázek besum1, United States.

Veřejná nástěnka k vyjasnění projektu

  • hsashankar
    hsashankar
    • Před 6 let

    Kindly do not close this till the end. working on a slick, good and responsive User experience

    • Před 6 let
    1. besum1
      Pořadatel soutěže
      • Před 6 let

      If you create a good product, send it to me, and I'll still buy it.

      • Před 6 let
  • RajakScripts
    RajakScripts
    • Před 6 let

    Hi, where did you get that "Current Market Data" sheet? Is it from www.treasury.gov? Could you provide its precise URL from where you pulled the data for that "Current Market Data" sheet? Thx!

    • Před 6 let
    1. RajakScripts
      RajakScripts
      • Před 6 let

      Ok.

      • Před 6 let
    2. RajakScripts
      RajakScripts
      • Před 6 let

      I'll submit my entry after created some part of it. Plan to use Bootstrap & PHP (instead of JS).

      • Před 6 let
  • sblancovilchez
    sblancovilchez
    • Před 6 let

    See the advances please. https://calculator-378c1.firebaseapp.com

    • Před 6 let
  • Codesoftic Tech Pvt Ltd
    Codesoftic Tech Pvt Ltd
    • Před 6 let

    Can you please explain formulas so that it is easy to use

    • Před 6 let
    1. Codesoftic Tech Pvt Ltd
      Codesoftic Tech Pvt Ltd
      • Před 6 let

      or you need just data show in web page

      • Před 6 let
    2. besum1
      Pořadatel soutěže
      • Před 6 let

      To see the formulas, unlock each sheet with the password "physics".

      • Před 6 let
  • DevvTime
    DevvTime
    • Před 6 let

    Hello there i am interested! i have a question, do you need same layout and contents in web pages? what i mean you need to transform the csv files to web pages?

    • Před 6 let
    1. besum1
      Pořadatel soutěže
      • Před 6 let

      It's not a csv file; it's a calculator.

      • Před 6 let
    2. besum1
      Pořadatel soutěže
      • Před 6 let

      I've updated the description.

      • Před 6 let

Zobrazit více komentářů

Jak začít se soutěžemi

  • Zadejte vaši soutěž

    Zveřejněte svou soutěž Rychlé a snadné

  • Získejte kupu návrhů

    Získejte spousty návrhů Z celého světa

  • Zvolte nejlepší návrh

    Zvolte nejlepší návrh Stáhněte si soubory - Je to snadné!

Zadejte soutěž nyní nebo se k nám připjte ještě dnes!