Skip to main content

Accessing LCGv2 from Excel

1 post / 0 new
HTY
HTY's picture
Accessing LCGv2 from Excel

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

 

AAVSO 49 Bay State Rd. Cambridge, MA 02138 aavso@aavso.org 617-354-0484