2 New Messages
Digest #2694
Messages
Mon Jul 15, 2013 12:31 am (PDT) . Posted by:
"Lawrence" lawleesh
Thanks Randy. This worked. Only problem is that advfn offers 5 years of data if you sign in and only 3 years if you don't. When you put formulae in excel, it won't retrieve the additional two years.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Those are just be normal EXCEL processing, so sure. You need to concatenate
> a string to change the URL, and I usually move the parameter for the
> concatenation to the end of the URL so it's just a single concatenation
> instead of two. So, something like:
>
> =RCHGetTableCell("
> http://markets.ft.com/research/Markets/Tearsheets/Financials?subview=BalanceSheet&s= "&B3,C3,">Cash
> and Short Term Investments")
>
> ...where B3 is your ticker symbol and C3 is which offset of year you want.
>
> On Sun, Jul 14, 2013 at 9:03 PM, Lawrence <lawrence.leesh@...> wrote:
>
> >
> > If I want the formula to get "1", "G05.SI" and "Cash and Short Term
> > Investments" from cell values, is that possible? So when I change the cells
> > it would retrieve another piece of info from another stock from another
> > year.
> >
>
--- In smf_addin@yahoogrou
>
> Those are just be normal EXCEL processing, so sure. You need to concatenate
> a string to change the URL, and I usually move the parameter for the
> concatenation to the end of the URL so it's just a single concatenation
> instead of two. So, something like:
>
> =RCHGetTableCell(
> http://markets.
> and Short Term Investments"
>
> ...where B3 is your ticker symbol and C3 is which offset of year you want.
>
> On Sun, Jul 14, 2013 at 9:03 PM, Lawrence <lawrence.
>
> >
> > If I want the formula to get "1"
> > Investments" from cell values, is that possible? So when I change the cells
> > it would retrieve another piece of info from another stock from another
> > year.
> >
>
Mon Jul 15, 2013 12:32 am (PDT) . Posted by:
"Lawrence" lawleesh
I meant FT.com, not advfn.
--- In smf_addin@yahoogroups.com , "Lawrence"; <lawrence.leesh@...> wrote:
>
> Thanks Randy. This worked. Only problem is that advfn offers 5 years of data if you sign in and only 3 years if you don't. When you put formulae in excel, it won't retrieve the additional two years.
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Those are just be normal EXCEL processing, so sure. You need to concatenate
> > a string to change the URL, and I usually move the parameter for the
> > concatenation to the end of the URL so it's just a single concatenation
> > instead of two. So, something like:
> >
> > =RCHGetTableCell("
> > http://markets.ft.com/research/Markets/Tearsheets/Financials?subview=BalanceSheet&s= "&B3,C3,">Cash
> > and Short Term Investments")
> >
> > ...where B3 is your ticker symbol and C3 is which offset of year you want.
> >
> > On Sun, Jul 14, 2013 at 9:03 PM, Lawrence <lawrence.leesh@> wrote:
> >
> > >
> > > If I want the formula to get "1", "G05.SI" and "Cash and Short Term
> > > Investments" from cell values, is that possible? So when I change the cells
> > > it would retrieve another piece of info from another stock from another
> > > year.
> > >
> >
>
--- In smf_addin@yahoogrou
>
> Thanks Randy. This worked. Only problem is that advfn offers 5 years of data if you sign in and only 3 years if you don't. When you put formulae in excel, it won't retrieve the additional two years.
>
> --- In smf_addin@yahoogrou
> >
> > Those are just be normal EXCEL processing, so sure. You need to concatenate
> > a string to change the URL, and I usually move the parameter for the
> > concatenation to the end of the URL so it's just a single concatenation
> > instead of two. So, something like:
> >
> > =RCHGetTableCell(
> > http://markets.
> > and Short Term Investments"
> >
> > ...where B3 is your ticker symbol and C3 is which offset of year you want.
> >
> > On Sun, Jul 14, 2013 at 9:03 PM, Lawrence <lawrence.
> >
> > >
> > > If I want the formula to get "1"
> > > Investments" from cell values, is that possible? So when I change the cells
> > > it would retrieve another piece of info from another stock from another
> > > year.
> > >
> >
>
Tidak ada komentar:
Posting Komentar