HL pricing over time revisited--help wanted
#75678
04/09/03 11:28 AM
|
Joined: Jan 2003
Posts: 487
plebetkin
OP
Member
|
OP
Member
Joined: Jan 2003
Posts: 487 |
a few years ago, there was quite a discussion on determining the future value of Harbor Lights limited edition pieces. I was not a member of this forum at the time, but I have searched around this thread and The Fog Horn and pieced together a lot of the discussion. I am very interested. However, the spreadsheet with the data is no longer available when one clicks on the link. This discussion was headed by J Timothy A.
I'm looking for the formula counterparts to the data presented at that time and a downloadable copy of the spreadsheet if possible. I'm intrigued by what that information applied today would reveal.
To refresh memories, there were factoids 10-11 and a lot of comments on them. I guess that the discussion had begun on AOL and was then updated here.
good friends mean good times
|
|
|
Re: HL pricing over time revisited--help wanted
#75679
04/10/03 02:40 PM
|
Joined: Jan 2003
Posts: 487
plebetkin
OP
Member
|
OP
Member
Joined: Jan 2003
Posts: 487 |
I've been e-mailed the spreadsheet. I'm still looking for the factoids that were not published on Collector Forums
good friends mean good times
|
|
|
Re: HL pricing over time revisited--help wanted
#75680
04/10/03 06:19 PM
|
Joined: Dec 1969
Posts: 1,133
JJ
Cruise Director
|
Cruise Director
Joined: Dec 1969
Posts: 1,133 |
Search the headings for all forums under factoid and you will come up with a bunch of them Jim Johnson
|
|
|
Re: HL pricing over time revisited--help wanted
#75681
04/10/03 07:10 PM
|
Joined: Dec 1969
Posts: 3,759
DANIEL
Saint
|
Saint
Joined: Dec 1969
Posts: 3,759 |
I did a search of Factoids in the Forum and came up with all 11. I don't remember any being in the AOL days.
DANIEL
|
|
|
Re: HL pricing over time revisited--help wanted
#75682
04/11/03 09:09 AM
|
Joined: Jan 2003
Posts: 487
plebetkin
OP
Member
|
OP
Member
Joined: Jan 2003
Posts: 487 |
I don't know what I'm doing wrong, but I searched under "all open forums" and could only turn up factoid 11, 7, and 4. I'm interested in trying to replicate the statistical study for all limited editions to see what floats up. What pieces using the statistics would be most valuable, least valuable today?
If anyone has any ideas how I can get the rest of the factoids and spreadsheets, please let me know. I was emailed on spreadsheet already and that was helpful, but not all formulae was on the spreadsheet.
Thanks to anyone who is able to help.
good friends mean good times
|
|
|
Re: HL pricing over time revisited--help wanted
#75683
04/11/03 09:32 PM
|
Joined: Aug 1999
Posts: 351
Jim Chesher
Member
|
Member
Joined: Aug 1999
Posts: 351 |
I find it interesting that when I do a Subject Line only search on "Factoid" I come up with ten items. They include: HL Factoid #2 HL Factoid #4 HL Factoid #7 Factoid #8 HL Factoid #9 HL Factoid #10 HL Factoid #11 part 1 - What to Buy? HL Factoid #11 part 2 - What to Buy? HL Factoid #11 part 3 - What to Buy? Download Factoid #11 Spreadsheet I don't understand why people are getting different search results. Additionally if you go to the spreadsheet that I sent you and look in cells A169 thru A195 you will see that there is data in the cell that isn't readily seen. If you select that cell you will be able to read its entire contents in the formula bar. Hope this helps.
|
|
|
Re: HL pricing over time revisited--help wanted
#75684
04/11/03 10:18 PM
|
Joined: Jan 2003
Posts: 487
plebetkin
OP
Member
|
OP
Member
Joined: Jan 2003
Posts: 487 |
thanks to all, and thanks Jim Chesher for e-mailing me the spreadsheet. I've gone to HL's site and gotten a full list of all limited editions and imposed that upon the spreadsheet you provided. Now I'm trying to update the column information to see how things play out. For prices, I think e-bay is most reflective of the type of secondary market people buy from today.
good friends mean good times
|
|
|
Re: HL pricing over time revisited--help wanted
#75685
04/11/03 10:21 PM
|
Joined: Jan 2003
Posts: 487
plebetkin
OP
Member
|
OP
Member
Joined: Jan 2003
Posts: 487 |
also, thanks for the tip on searching on subject line only. It gave me the same results you posted. I assume that the missing numbers mean that there were no factoids?
good friends mean good times
|
|
|
Re: HL pricing over time revisited--help wanted
#75686
04/12/03 02:31 AM
|
Joined: Dec 1969
Posts: 2,300
JTimothyA
Saint
|
Saint
Joined: Dec 1969
Posts: 2,300 |
Looks like a nice job of forum archaeology, Peter. Early entries in The Factoid Series partly derive from messages I posted on the AOL forum that was the predecessor to these fora. Not all survived - at least in my databanks. Alas, some slices of history are lost in time. This is vaguely documented in my final msg. of the thread here . The download of my spreadsheet did not survive the transition to upgraded forum software. There used to be little mailboxes for each of the forums that served as repositories for the forum admins to post news, updates, welcome messages, and the like. That is where the spreadsheet was stashed. A software upgrade seems to have done away with those little mailboxes. I'm glad someone sent you a copy. Does the copy you received have a version number in the footnotes? Version 1.05 or later is the one you want. Hopefully you've figured out the formulas and whatnot. T
|
|
|
Re: HL pricing over time revisited--help wanted
#75687
04/12/03 11:36 AM
|
Joined: Aug 1999
Posts: 351
Jim Chesher
Member
|
Member
Joined: Aug 1999
Posts: 351 |
It was version 1.06;)
|
|
|
Re: HL pricing over time revisited--help wanted
#75688
04/14/03 12:12 AM
|
Joined: Jan 2003
Posts: 487
plebetkin
OP
Member
|
OP
Member
Joined: Jan 2003
Posts: 487 |
I'm trying to figure out all the formulas. I have gathered the spreadsheet from Harbor Lights that lists their entire collection. I'm going to run everything on that list and see what floats out. I'm thinking that e-bay is the secondary market source to use since that seems to be accessible by the majority of people over storefront establishments.
good friends mean good times
|
|
|
Re: HL pricing over time revisited--help wanted
#75689
04/14/03 07:51 AM
|
Joined: Dec 1969
Posts: 12,331
Bob M
Saint
|
Saint
Joined: Dec 1969
Posts: 12,331 |
The only problem with eBay is the items run "hot & cold". Sometimes a piece sells well below retail then all of a sudden it commands more of a premium price. There are a lot of bargains on eBay accompanied by items that sell for more than a bargain-hunter would be willing to pay. Go figure... Bob
|
|
|
Re: HL pricing over time revisited--help wanted
#75690
04/16/03 12:52 AM
|
Joined: Jan 2003
Posts: 487
plebetkin
OP
Member
|
OP
Member
Joined: Jan 2003
Posts: 487 |
if I follow e-bay over a period of time, I'll start to get a picture of price ranges for specific lights.
I also would like to see if one or two post-market dealers would provide price points for as many lights as they have. The more secondary market information that is available, the more accurate the predictions that can be made.
good friends mean good times
|
|
|
Re: HL pricing over time revisited--help wanted
#75691
04/16/03 02:07 AM
|
Joined: Dec 1969
Posts: 1,133
JJ
Cruise Director
|
Cruise Director
Joined: Dec 1969
Posts: 1,133 |
Some more oldies: http://www.lighthousekeepers.com/cgi-bin/forumscgi/ultimatebb.cgi?ubb=get_topic;f=16;t=000017#000008 http://www.lighthousekeepers.com/forums/ultimatebb.php?ubb=get_topic;f=28;t=000042 http://www.lighthousekeepers.com/forums/Forum28/HTML/000027.html
|
|
|
Re: HL pricing over time revisited--help wanted
#75692
04/16/03 04:06 PM
|
Joined: Jan 2003
Posts: 487
plebetkin
OP
Member
|
OP
Member
Joined: Jan 2003
Posts: 487 |
thanks for the new source materials.
good friends mean good times
|
|
|
Re: HL pricing over time revisited--help wanted
#75693
04/20/03 12:09 AM
|
Joined: Dec 1969
Posts: 2,300
JTimothyA
Saint
|
Saint
Joined: Dec 1969
Posts: 2,300 |
If you want assistance in understanding my spreadsheet formulas, just ask. A small insight may be gleaned from HL Factoid #11 part 3 - What to Buy? For others who are interested, it appears there is a message pointing to the downloads, however the links go nowhere. --->>Yo JC - are files still available? (cf. Message and Download Page ) T
|
|
|
Re: HL pricing over time revisited--help wanted
#75694
04/21/03 12:41 AM
|
Joined: Jan 2003
Posts: 487
plebetkin
OP
Member
|
OP
Member
Joined: Jan 2003
Posts: 487 |
thanks for the offer for help. I'll probably have questions for you soon.
good friends mean good times
|
|
|
Re: HL pricing over time revisited--help wanted
#75695
04/21/03 01:01 AM
|
Joined: Dec 1969
Posts: 13,047
Webmaster
Saint
|
Saint
Joined: Dec 1969
Posts: 13,047 |
They don't appear to be there. Do you have them still? Not sure why, since the downloads folder is.
|
|
|
Re: HL pricing over time revisited--help wanted
#75696
04/21/03 04:22 AM
|
Joined: Dec 1969
Posts: 13,047
Webmaster
Saint
|
Saint
Joined: Dec 1969
Posts: 13,047 |
I have reloaded those files from my hard drive. I think they may have gotten lost when we changed servers. The one file link that doesn't work refers to the formulas explanation. Use this link instead: http://www.lighthousekeepers.com/downloads/Formulas.htm
|
|
|
Re: HL pricing over time revisited--help wanted
#75697
04/21/03 11:59 PM
|
Joined: Dec 1969
Posts: 2,300
JTimothyA
Saint
|
Saint
Joined: Dec 1969
Posts: 2,300 |
That's great - thanks JC!!
T
|
|
|
Re: HL pricing over time revisited--help wanted
#75698
04/22/03 01:06 AM
|
Joined: Jan 2003
Posts: 487
plebetkin
OP
Member
|
OP
Member
Joined: Jan 2003
Posts: 487 |
I've loaded most of the ebay HL transactions for April into the spreadsheet that was from 2000. How do I get it from my computer to this forum?
good friends mean good times
|
|
|
|
Forums39
Topics16,978
Posts184,640
Members2,579
|
Most Online10,155 Jan 14th, 2020
|
|
0 registered members (),
1,316
guests, and 3
spiders. |
Key:
Admin,
Global Mod,
Mod
|
|
|