Accessing LCGv2 from Excel

Affiliation
None
Fri, 06/02/2017 - 18:16

I've been very successfully been able to access version 1 of the lightcurve generator for a couple of years now using a hyperlink from within Excel.  An example is below calling the last three years of V and Vis data for a variable name in cell A2:

=HYPERLINK("http://www.aavso.org/lcg/plot?auid="&A2&"&lastdays=1096&obscode=HTY&obscode_symbol=2&calendar=calendar&start=&stop=&obstotals=on&grid=on&pointsize=1&width=800&height=450&mag1=&mag2=&mean=&visual=on&uband=&bband=&v=on&r=&iband=&j=&h=&unknown=&unvalidat",A2)

I haven't been able to find the magic formula to bring up LCGv2.  I've tried simply changing /lcg/ to LCGv2 as it appears in the URL on when LCGV2 is called from the home page.  Is it possible to access V2 in this way?

 

Tim