Welcome Guest
Log In | Register )
You last visited December 11, 2016, 8:42 am
All times shown are
Eastern Time (GMT-5:00)

Improvements to the jackpot history pages

Topic closed. 7 replies. Last post 8 years ago by psykomo.

Page 1 of 1
PrintE-mailLink
Todd's avatar - Cylon 2.gif
Chief Bottle Washer
New Jersey
United States
Member #1
May 31, 2000
23277 Posts
Online
Posted: December 8, 2008, 6:24 pm - IP Logged

I just finished installing significant improvements to the jackpot history page for each game, with expanded statistical information, native currencies (for non-US dollar jackpots), and US dollar equivalents.

The Jackpot History page for a game can be viewed by clicking on the game, and then selecting "Jackpot History" from the popup menu.

For example, here is the Mega Millions Jackpot History page: http://www.lotterypost.com/game/45/jackpot

Here are some examples of some non-US Dollar games.

In the new statistics, notice that it not only tells you the largest jackpot size, but it also tells you how many times the jackpot has reached that level, and the date of the last time it reached that level.  The other stats have the same tyoe of analysis.

However, the biggest and most difficult part of this new functionality was the conversion of the Lottery Post jackpot database to be fully able to handle native currencies, and to reconstruct all of the non-US Dollar data in multi-currency.  (You can see on the sample pages that the database is storing both the native currency as well as the USD equivalent.)

All of the conversion rates performed — even on the historical data — were done using the actual conversion rate that was in effect on the day of the drawing.  In order to do that, I had to reconstruct a history of conversion rates going all the way back.  It was a pretty big job.

Although it was a big job, I think it's well worth it.  The jackpot data at Lottery Post is now — as far as I know — the only lottery jackpot database to have this kind of historical detail, providing the ability to do analysis and general stats that cannot be achieved anywhere else.

The multi-currency jackpots show up anyplace jacks are displayed.  For example, the main results page shows a top-10 jackpot list.  And the Wordwide Jackpots page shows all of the jackpots available in the database, sortable in a variety of ways.  Also, the individual state/province results pages will show native currencies, if they are used.

Although Lottery Post traditionally has (and continues to have) a huge US-based audience, it's worldwide viewership has increased a lot.  Showing jackpot amounts in the native currencies is very important to that audience, and the Lottery Post-exclusive US Dollar equivalent information is a great way to compare jackpot amounts between different countries.

Behind the scenes I have constructed a very accurate currency-conversion system, which can apply both real-time and historical conversions accurately and quickly.

I also took the opportunity to fill in some missing data.  All of the following games now have both lottery results and jackpot data (with native currency and USD equivalent at the time) going all the way back to the first drawing of the game.

Your Feedback (please!)

I am looking for your feedback on the new jackpot statistics.

I came up with some stats that were of interest to me, but I know there are lots of other ways of looking at historical jackpot data.

Do you have additional views you'd like to see?  How about different ways to use the multi-currency information?

 

Check the State Lottery Report Card
What grade did your lottery earn?

 

Sign the Petition for True Lottery Drawings
Help eliminate computerized drawings!

    dvdiva's avatar - 8ball

    United States
    Member #2338
    September 17, 2003
    2063 Posts
    Offline
    Posted: December 10, 2008, 1:10 am - IP Logged

    Thanks for your hard work. The largest prize listed in the Canadian 6/49 game is wrong from what I can tell.  www.wclc.com/FAQ/  lists the highest prizes. Nice that the currency is listed as well.

      Todd's avatar - Cylon 2.gif
      Chief Bottle Washer
      New Jersey
      United States
      Member #1
      May 31, 2000
      23277 Posts
      Online
      Posted: December 10, 2008, 1:26 am - IP Logged

      Might have been a case where the awarded jackpot far exceeded the advertised jackpot.  It happens all the time when jackpots reach record amounts.

      I updated the jackpot in the LP database to reflect the actual amount, as stated on the official site.

      Of course, the currency conversion to US Dollars reflects the accurate conversion rate on the date of the drawing. Wink

       

      Check the State Lottery Report Card
      What grade did your lottery earn?

       

      Sign the Petition for True Lottery Drawings
      Help eliminate computerized drawings!

        JAP69's avatar - alas
        South Carolina
        United States
        Member #6
        November 4, 2001
        8790 Posts
        Offline
        Posted: December 21, 2008, 9:50 pm - IP Logged

        I just finished installing significant improvements to the jackpot history page for each game, with expanded statistical information, native currencies (for non-US dollar jackpots), and US dollar equivalents.

        The Jackpot History page for a game can be viewed by clicking on the game, and then selecting "Jackpot History" from the popup menu.

        For example, here is the Mega Millions Jackpot History page: http://www.lotterypost.com/game/45/jackpot

        Here are some examples of some non-US Dollar games.

        In the new statistics, notice that it not only tells you the largest jackpot size, but it also tells you how many times the jackpot has reached that level, and the date of the last time it reached that level.  The other stats have the same tyoe of analysis.

        However, the biggest and most difficult part of this new functionality was the conversion of the Lottery Post jackpot database to be fully able to handle native currencies, and to reconstruct all of the non-US Dollar data in multi-currency.  (You can see on the sample pages that the database is storing both the native currency as well as the USD equivalent.)

        All of the conversion rates performed — even on the historical data — were done using the actual conversion rate that was in effect on the day of the drawing.  In order to do that, I had to reconstruct a history of conversion rates going all the way back.  It was a pretty big job.

        Although it was a big job, I think it's well worth it.  The jackpot data at Lottery Post is now — as far as I know — the only lottery jackpot database to have this kind of historical detail, providing the ability to do analysis and general stats that cannot be achieved anywhere else.

        The multi-currency jackpots show up anyplace jacks are displayed.  For example, the main results page shows a top-10 jackpot list.  And the Wordwide Jackpots page shows all of the jackpots available in the database, sortable in a variety of ways.  Also, the individual state/province results pages will show native currencies, if they are used.

        Although Lottery Post traditionally has (and continues to have) a huge US-based audience, it's worldwide viewership has increased a lot.  Showing jackpot amounts in the native currencies is very important to that audience, and the Lottery Post-exclusive US Dollar equivalent information is a great way to compare jackpot amounts between different countries.

        Behind the scenes I have constructed a very accurate currency-conversion system, which can apply both real-time and historical conversions accurately and quickly.

        I also took the opportunity to fill in some missing data.  All of the following games now have both lottery results and jackpot data (with native currency and USD equivalent at the time) going all the way back to the first drawing of the game.

        Your Feedback (please!)

        I am looking for your feedback on the new jackpot statistics.

        I came up with some stats that were of interest to me, but I know there are lots of other ways of looking at historical jackpot data.

        Do you have additional views you'd like to see?  How about different ways to use the multi-currency information?

        Now all that was a lot of work.

        Lottery Post has become known worldwide.

        Thumbs Up

        MAGA

          psykomo's avatar - animal shark.jpg

          United States
          Member #4877
          May 30, 2004
          5124 Posts
          Offline
          Posted: December 30, 2008, 8:42 pm - IP Logged

          Now all that was a lot of work.

          Lottery Post has become known worldwide.

          Thumbs Up

          thank-U>>>>>>>>>>>>>>>>>>>>>>4-UR>>>>>>>Lottery Post>>>!!!!

          LOL---22222222222222222222222U&ALLJP>>>>>>>Lottery Post>>>!!!!

          "@))()>>>>>>>>>>>2009>1****!!

          worldWIDE>>>>>>2009>"yes"!!!

          Jack-in-the-BoxBig Grin SantaBig Grin Angel

          LOL>>$

          psykomo

            TotallyDavis's avatar - Lottery-061.jpg
            New Member
            North Charleston, SC
            United States
            Member #69214
            January 6, 2009
            45 Posts
            Offline
            Posted: January 6, 2009, 5:24 pm - IP Logged

            Thanks for your hard work.  It's always great seeing people taking math, streamlining it, and making it attractive for the rest of us.

             

            Your efforts will be appreciated!

              psykomo's avatar - animal shark.jpg

              United States
              Member #4877
              May 30, 2004
              5124 Posts
              Offline
              Posted: January 8, 2009, 6:12 pm - IP Logged

              Thanks for your hard work.  It's always great seeing people taking math, streamlining it, and making it attractive for the rest of us.

               

              Your efforts will be appreciated!

              "someone" once said..........................................

              "today is the day"!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

              that person was Mel Fisher !!!!!!!!!!!!!!!!!!!!!!!!!

              he was L@@K'g for GOLD off FL coast!!!!!!!!!

              thank's Todd>>for UR investment in D-LP!!!

              psykomo

                psykomo's avatar - animal shark.jpg

                United States
                Member #4877
                May 30, 2004
                5124 Posts
                Offline
                Posted: January 13, 2009, 1:06 am - IP Logged

                "someone" once said..........................................

                "today is the day"!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

                that person was Mel Fisher !!!!!!!!!!!!!!!!!!!!!!!!!

                he was L@@K'g for GOLD off FL coast!!!!!!!!!

                thank's Todd>>for UR investment in D-LP!!!

                psykomo

                ...not to mention.......Todd

                   lips for you,

                 ears for you,

                   arms for yoy,

                and everything else for you!

                all D gull's of ODK & FABRIC.com

                luv "U" & "D" Lottery Post^^^^^!

                "how-u-do-dat-Todd???"

                ?????????????????????

                lol

                PSYKOMO