Can the LEx database be accessible via an excel/csv download so that we can do analysis on available hops?
What type of analysis do you want to do?
We have many new analytics in the pipeline, most of which will be end up under the LEx Insights menu. We’ll announce those via this community as they are released.
There are also additional improvements coming to views/filters/sorting/etc. of active listings.
If you can give us more details about what exactly you want to accomplish/analyze, that would help a lot.
1 Like
Want to look at varietals by year and hop type (t90 vs t45, etc) and be able to calculate the average prices with standard deviations and min/max values and other permutations to more appropriately assess state of the market for hops at certain prices. Big picture trying to use data in the spot market to make better educated decisions for contracts.
Sorry, I missed your reply - just now seeing this.
We definitely don’t allow open access to our database; however, part of what you are looking for is available via a combination of “Lex Insights” and “Price History” (see Data & Tools menu). After you take the brief 6 question survey, you immediately get access to LEx Insights, which unlocks some additional information for specific varieties:
We haven’t received many feature requests or demand for additional insights from the community, so definitely let us know (by replying here) if there is anything specific that you would like to see become available via the Data & Tools menu. We gauge interest in new features based on community feedback - if someone posts a request to this community and 50 brewers hit the like button, odds are we’ll build it.
Beyond what is currently available via LEx Insights, Price History, and takeaways like “is my contract price better or worse than other brewers?” (available via Contract Manager), we have offered additional market analytics & insights via a few channels in the past and hope to expand on this in the future…a few examples:
-
Presentations at various industry events. (A few of which are archived in our YouTube channel)
-
Occasional blog posts, archived in this community site
-
Occasional interviews with the media
-
Conversations at our conference booths (CBC, HGA, etc.)
Most importantly, We will be presenting our newest set of market insights during The Hop Pendulum next week in Portland! And it’s not too late to make requests if there are specific metrics that you’d like to see/hear about. Just check the banner at the top of https://lupulinexchange.com or send your request to hga2020@lupulinexchange.com
Thanks!