anandbohra
11-20-2007, 03:43 AM
Hi All
I am member of SMF Yahoo add in group there while surfing I got this file named as Get Yahoo Multiple History.xls
In this file there is one strange concept i come to know that after downloading prices the moment u double click on scrip heading u get the prices to be plotted in the chart next sheet
there that genius fellow used formula for series as
=SERIES(,,'Get Yahoo Multiple History double click chart.xls'!GraphRange1,1)
but strange thing is I am unable to locate range "GraphRange1", & how he update it runtime.
the file i am uploading is without password so pl have a look & tell me what logic he has used & when & where he update this range.
(not able to contact original author as found this file uploaded in files section of yahoo group SMF Addin )
so pl help me & also download it to get Yahoo historical prices at your Excel sheet immediately
I am member of SMF Yahoo add in group there while surfing I got this file named as Get Yahoo Multiple History.xls
In this file there is one strange concept i come to know that after downloading prices the moment u double click on scrip heading u get the prices to be plotted in the chart next sheet
there that genius fellow used formula for series as
=SERIES(,,'Get Yahoo Multiple History double click chart.xls'!GraphRange1,1)
but strange thing is I am unable to locate range "GraphRange1", & how he update it runtime.
the file i am uploading is without password so pl have a look & tell me what logic he has used & when & where he update this range.
(not able to contact original author as found this file uploaded in files section of yahoo group SMF Addin )
so pl help me & also download it to get Yahoo historical prices at your Excel sheet immediately