CruiseFish Forum

    « 1 2

    CT, United States
    joined May 2010
    post 2/2
    cruiser #607
    Re: PAST PRICING HISTORY

    Titus thank you so much.

    Queens, NY, United States
    joined May 2010
    post 1/4
    cruiser #1338
    Re: PAST PRICING HISTORY

    Titus..

    Great site you have here!!

    OH, United States
    joined Jul 2010
    post 3/20
    cruiser #2739
    Re: PAST PRICING HISTORY

    OMGosh...Titus thank you so much. I've been trying to find out some past history from early last year. This was absolutely beyond FABULOUS!

    You rock! :grin:


    Yzguy

    Beaverton, OR, United States
    joined Mar 2013
    post 1/7
    cruiser #14975
    Re: PAST PRICING HISTORY

    Regarding "past price history" data.  I love this feature.  However, it is limited to a single specific sailing.  Is it possible to snag a whole table in csv format of past history?  That would allow exporting to a spreadsheet for all sorts of manipulation.  I'm interested in looking for pricing patterns for the various cruiselines.  Ideally, it would be a dump of all historical data for the last year... or even multiple years.  This would definately affect the bandwidth of your site so it would make sense to charge for this.  Not sure what would be fair, but I'd definately pay $20 for a one time download.  It seems like the hardest part wouldn't be the actual code to generate/transfer the csv file... but the code required to support an additional pricing structure!  :)

    Alternatively, perhaps this could be done through an on-the-side ad hoc email/paypal transaction?

    relaxing with Ernie
    Quebec, QC, Canada
    joined Apr 2010
    post 487/625
    cruiser #3
    Re: PAST PRICING HISTORY

    On April 06, 2013 at 02:02 AM, robinsonhome wrote:

    Regarding "past price history" data.  I love this feature.  However, it is limited to a single specific sailing.  Is it possible to snag a whole table in csv format of past history?  That would allow exporting to a spreadsheet for all sorts of manipulation.  I'm interested in looking for pricing patterns for the various cruiselines.  Ideally, it would be a dump of all historical data for the last year... or even multiple years.  This would definately affect the bandwidth of your site so it would make sense to charge for this.  Not sure what would be fair, but I'd definately pay $20 for a one time download.  It seems like the hardest part wouldn't be the actual code to generate/transfer the csv file... but the code required to support an additional pricing structure!  :)

    Alternatively, perhaps this could be done through an on-the-side ad hoc email/paypal transaction?

    What do you mean by "whole table"? Several sailings in one csv file? That would be difficult as each price of a single sailing already occupies two coordinates: price and time. So a single csv export could only cover a single sailing.

    Maybe you have a precise idea of a format that would be convenient for you? If so please let me know.


    cruisefish.net administrator

    Beaverton, OR, United States
    joined Mar 2013
    post 2/7
    cruiser #14975
    Re: PAST PRICING HISTORY

    Titus,

    Yes, I was referring to several sailings in one csv files.  As you pointed out, you've already got some 2D data in your tables.  For a spreadsheet, this would need to be flattened out and fields couldn't be overloaded.  This means some columns will be full of repeated redundant information.  

    As an example, I looked at the past data table generated for:

    CruiseLine=RCCL; Ship="Oasis of the Seas"; "Month=2013 April"; Cruise="06 Apr 2013"

    I've converted this to a google docs spreadsheet located here (actually, I converted about 80% of it but decided that I didn't need to convert the "whole" thing since it was only for example purposes):
    https://docs.google.com/spreadsheet/ccc?key=0ApQ0kgg6GaBXdEh4MFBzckppM0JvbnFuOGd2Yi03dGc&usp=sharing

    These are the headings:
    "Cruise Line"    Ship    "Sail Date"    "Cabin Class"    "Cabin Type"    "Cabin Category"    "Rate Category"    "Rate Change Date"    Currancy    Rate

     

    Note that I didn't make use of the "updated" dates simply because I didn't comprehend how something could be "updated" with new prices that remain constant.  I'm sure there is an obvious explanation, but decided to ignore "updated" for now.  Perhaps that is when a category/price combination is full or is re-opened?  So, "updated" date may or may not be relevent for purposes of predicting cruiseline pricing behavior, but I won't know for sure until I understand its purpose.

    In any case, having access to this historical price data could be very useful for generating all sorts of pivot tables or for writing programs that analyze various aspects about the industry.

    Thanks,
    David Robinson

    Beaverton, OR, United States
    joined Mar 2013
    post 3/7
    cruiser #14975
    Re: PAST PRICING HISTORY

    If you were to do something like this, I would envision that those items that generically apply to a specific person such as currancy and special discount types would be selectable and apply to the whole table (so, I left this data out of the example spreadsheet).  My example spreadsheet assumes US currancy and "standard" rate.

    I'm an engineer by trade, and know how easy it is for "feature creep" to get out of control.  So, I completely understand if you didn't want to do something like this.  Your site is amazing already for those of us who like to look at and analyze data.  Just from poking around, I can already see that some cruise lines pretty consistantly have a steadily increasing price model and some like to flash "attention getting" prices for a day or two just to garner attention (likely corresponding with national newspaper ads adversiting super low prices which then disappear by the time a reader tries to book).

    Thanks,
    David

    « 1 2