fredmiranda.com
Login

Moderated by: Fred Miranda
  New fredmiranda.com Mobile Site
  New Feature: SMS Notification alert
  New Feature: Buy & Sell Watchlist
  

FM Forums | Leica & Alternative Gear | Join Upload & Sell

  

Archive 2013 · Lens Price Database, Lens$db-v24

  
 
jcolwell
Offline
• • • • • • •
Upload & Sell: On
p.1 #1 · Lens Price Database, Lens$db-v24


Lens Price Database version 24 update, Lens$db-v24, http://tinyurl.com/jcolwell-lensdb

The Lens Price Database, Lens$db, has prices and physical specifications for over 475 lenses, including: all Canon EF prime lenses and EF Extenders; all Canon EF L-series zoom lenses, plus a few others; a variety of lenses from Sigma, Tamron and Tokina; a large selection of “alternative” manual focus lenses from Carl Zeiss, Leica, Nikon, Olympus, Pentax, Voigtlander, and other brands; a selection of Medium Format Mamiya 645 lenses that are more-or-less compatible with EOS cameras, and with the Mirex Tilt-Shift adapter; and, Fujifilm XF lenses, plus a small selection of LM and LTM rangefinder-style lenses. The prices are mostly for used equipment in excellent to mint condition, based on eBay sales and list prices at many camera stores.

Cheers, Jim



May 04, 2013 at 09:32 AM
RustyBug
Offline
• • • • • • •
Upload & Sell: On
p.1 #2 · Lens Price Database, Lens$db-v24


Version 24 ... a labor of love and dedication rarely seen in much of today's world. I think I picked up my first one around V. 11. Thanks for all that you give to us here, both in the database and so much more. You truly add value to FM for your fellow FM members in many ways.

... first round's on me whenever our paths should cross.



May 04, 2013 at 09:59 AM
wfrank
Offline
• • • •
Upload & Sell: Off
p.1 #3 · Lens Price Database, Lens$db-v24


Thanks for all hard work Jim, much appreciated!

It would be interesting to see price development over time for some of the lenses. A consensus seem to be that prices of C/Y Zeiss have risen the last couple of years. Is there a way to d/l old versions (dated?) of the database? If so I would be happy to check a few lenses and post the results here.

Free beer applies in Sthlm too



May 04, 2013 at 03:39 PM
jcolwell
Offline
• • • • • • •
Upload & Sell: On
p.1 #4 · Lens Price Database, Lens$db-v24


Thanks guys.

I'm already starting to plan my most excellent free-beer adventure. I figure I'll start in Southern Illinois, and then head over to Sweden. I'll try to take advantage of any other opportunities that might come up...

I agree that the CZ prices have risen in the last couple of years. I've attached a graph showing price data trends for the CZ Planar 85/1.4. It's the only CZ lens that I've been explicitly following, along with a variety of Canon and other Alt lenses.

All of the Lens$db database versions are still online. You can simply edit the url to access older versions. For example,

http://www.jcolwell.ca/photography/lens$db/Lens$db-v24.xlsx
http://www.jcolwell.ca/photography/lens$db/Lens$db-v23.xlsx
http://www.jcolwell.ca/photography/lens$db/Lens$db-v22.xlsx
http://www.jcolwell.ca/photography/lens$db/Lens$db-v21.xlsx
http://www.jcolwell.ca/photography/lens$db/Lens$db-v20.xls
http://www.jcolwell.ca/photography/lens$db/Lens$db-v19.xls

Note that the .xls file extension changed to .xlsx at version 21.

This version naming convention should be consistent all the way back to v-03. Feel free to do some lens price database anthropology.

Cheers, Jim

P.S. Kent, Wilhelm's kind offer seems to apply to more than just the first round. I'm just sayin'...







May 04, 2013 at 04:38 PM
wfrank
Offline
• • • •
Upload & Sell: Off
p.1 #5 · Lens Price Database, Lens$db-v24


Of course Rusty would get one or two too :-)

Thanks for the links but your sheets are protected so its not possible to copy cells for some reason I dont understand. But never mind your graph tells a story which is probably representative. Flattish 2006-2010 then up about 25-30% or so.




May 04, 2013 at 05:33 PM
jcolwell
Offline
• • • • • • •
Upload & Sell: On
p.1 #6 · Lens Price Database, Lens$db-v24


The .xls and .xlsx files are protected worksheets, so you can't change and then save them, but you should be able to copy and paste to a new worksheet: select range with mouse or keypad; open new workbook; use paste_special/values, and you should have the contents. Use paste_special column_widths on the same selection, and you should be where you want to be. The formulae are protected, not the values.

P.S. I can send you the unprotected files, if you want them.



May 04, 2013 at 07:09 PM
jcolwell
Offline
• • • • • • •
Upload & Sell: On
p.1 #7 · Lens Price Database, Lens$db-v24


wfrank wrote:
Of course Rusty would get one or two too :-)


I was refering to his offer to pay for the first round, only.

Maybe we'll both show up...













May 04, 2013 at 07:46 PM
wfrank
Offline
• • • •
Upload & Sell: Off
p.1 #8 · Lens Price Database, Lens$db-v24


I know that place :-)


May 05, 2013 at 07:26 AM
inglis
Offline
• •
Upload & Sell: Off
p.1 #9 · Lens Price Database, Lens$db-v24


Wonderful collection
and now all the way back to 3!!
(except 13)
Thanks so much Jim



May 05, 2013 at 07:11 PM
freaklikeme
Offline
• • • • • •
Upload & Sell: Off
p.1 #10 · Lens Price Database, Lens$db-v24


Make Colorado a stop on the tour, Jim. A, we have more micro-breweries than residents, and two, I'll be happy to supply you with examples of them all while you tour the southern Rockies.


May 05, 2013 at 09:16 PM
SunBlack
Offline
• •
Upload & Sell: Off
p.1 #11 · Lens Price Database, Lens$db-v24


Thank for the update.
As i wrote some time ago, i'd be great if Nikon AF lens are added.....



May 09, 2013 at 01:49 AM
jcolwell
Offline
• • • • • • •
Upload & Sell: On
p.1 #12 · Lens Price Database, Lens$db-v24


Thanks everybody.

freaklikeme wrote:
Make Colorado a stop on the tour, Jim. A, we have more micro-breweries than residents, and two, I'll be happy to supply you with examples of them all while you tour the southern Rockies.


I'll be in Boulder for a wedding in late June. We might have a chance to hook up.


SunBlack wrote:
Thank for the update.
As i wrote some time ago, i'd be great if Nikon AF lens are added.....


An infinite number of Canon users, typing for an infinite length of time might be able to do this, but they'd probably get the prices wrong.



May 09, 2013 at 06:01 AM
johnahill
Offline
• • • • •
Upload & Sell: Off
p.1 #13 · Lens Price Database, Lens$db-v24


Nice one Jim


May 09, 2013 at 06:51 AM
freaklikeme
Offline
• • • • • •
Upload & Sell: Off
p.1 #14 · Lens Price Database, Lens$db-v24


jcolwell wrote:
Thanks everybody.

I'll be in Boulder for a wedding in late June. We might have a chance to hook up.


Fantastic. But, just to clarify, I did mean samples of the micro-brews, not the residents. They aren't mine to give away.




May 12, 2013 at 02:20 AM
jcolwell
Offline
• • • • • • •
Upload & Sell: On
p.1 #15 · Lens Price Database, Lens$db-v24





May 12, 2013 at 06:51 AM





FM Forums | Leica & Alternative Gear | Join Upload & Sell

    
 

Welcome back
Log in to your account