5 Messages
Digest #3979
Messages
Sat Apr 22, 2017 9:30 am (PDT) . Posted by:
climbermel
Randy it shows the Barchart versions were obsolete as of 2016-11-01.
Yahoo http://c.finance.a1.b.yahoo.com/advances http://c.finance.a1.b.yahoo.com/advances has 13822-13861 (Pete's Dashboard Chart) but it is missing the TSX and TSX-V numbers 13901-13920
Thanks,
Mel
Yahoo http://c.finance.a1.b.yahoo.com/advances http://c.finance.a1.b.yahoo.com/advances has 13822-13861 (Pete's Dashboard Chart) but it is missing the TSX and TSX-V numbers 13901-13920
Thanks,
Mel
Sat Apr 22, 2017 9:38 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yes, the Barchart ELEMENTS are obsolete, but the template has the formulas
needed to extract the data. Unfortunately, the formulas couldn't be used as
element definitions, because the EVALUATE() function has length
limitations, both in the formula and in the intermediate text results.
On Sat, Apr 22, 2017 at 9:30 AM, climbermel@
...wrote:
>
> Randy it shows the Barchart versions were obsolete as of 2016-11-01.
>
> Yahoo http://c.finance.a1.b.yahoo.com/advances has 13822-13861 (Pete's
> Dashboard Chart) but it is missing the TSX and TSX-V numbers 13901-13920
>
needed to extract the data. Unfortunately, the formulas couldn't be used as
element definitions, because the EVALUATE() function has length
limitations, both in the formula and in the intermediate text results.
On Sat, Apr 22, 2017 at 9:30 AM, climbermel@
...wrote:
>
> Randy it shows the Barchart versions were obsolete as of 2016-11-01.
>
> Yahoo http://c.finance.a1.b.yahoo.com/advances has 13822-13861 (Pete's
> Dashboard Chart) but it is missing the TSX and TSX-V numbers 13901-13920
>
Sat Apr 22, 2017 9:53 am (PDT) . Posted by:
dieterengelke
Hi Randy,
recently one of my older spreadsheets stoppped working.
For example one of the Formulae where S26="SPY":
=RCHGetYahooHistory(S26,JAHR($D$20-1),MONAT($D$20-1),TAG($D$20-1),JAHR($D$20-1),MONAT($D$20-1),TAG($D$20-1),,"A",0)
Any help?
Regards
Dieter
diengelke@live.com
recently one of my older spreadsheets stoppped working.
For example one of the Formulae where S26="SPY":
=RCHGetYahooHistory(S26,JAHR($D$20-1),MONAT($D$20-1),TAG($D$20-1),JAHR($D$20-1),MONAT($D$20-1),TAG($D$20-1),,"A",0)
Any help?
Regards
Dieter
diengelke@live.com
Sat Apr 22, 2017 11:12 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Are you using the most current version of the add-in, which contains an
update for that function?
On Sat, Apr 22, 2017 at 9:53 AM, diengelke@
...wrote:
> recently one of my older spreadsheets stoppped working.
>
> For example one of the Formulae where S26="SPY":
>
> =RCHGetYahooHistory(S26,JAHR($D$20-1),MONAT($D$20-1),TAG($D$
> 20-1),JAHR($D$20-1),MONAT($D$20-1),TAG($D$20-1),,"A",0)
>
> Any help?
>
>
update for that function?
On Sat, Apr 22, 2017 at 9:53 AM, diengelke@
...wrote:
> recently one of my older spreadsheets stoppped working.
>
> For example one of the Formulae where S26="SPY"
>
> =RCHGetYahooHistory
> 20-1),JAHR($
>
> Any help?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar