Selasa, 25 Oktober 2016

[smf_addin] Digest Number 3825

4 Messages

Digest #3825
1a
1b
Re: Google Net PPE by "Randy Harmelink" rharmelink
2b
Re: yahoo history array start date by "Randy Harmelink" rharmelink

Messages

Mon Oct 24, 2016 2:39 am (PDT) . Posted by:

Chovek2

That's great. I can use that, thanks. Can I the formula so it refers to a cell address for the ticker?

Mon Oct 24, 2016 8:13 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yup. Just use normal EXCEL concatenation to create the URL.

On Mon, Oct 24, 2016 at 2:39 AM, keith@
​...wrote:

>
> That's great. I can use that, thanks. Can I the formula so it refers to
> a cell address for the ticker?
>
>

Mon Oct 24, 2016 3:54 am (PDT) . Posted by:

cs.holdings

Hi Randy

Im trying to use the yahoo historical array. I'd like the start date to begin with this calendar year from Jan 4, 2016 ...and wrote:

=RCHGetYahooHistory("^GSPC",2016,01,04,,,,"w","dA",,,1)

But, the comment comes with "problems with start date". If I leave the dats switches empty, it works fine, but provides data to the size of the array

Do you have a suggestion?


Mon Oct 24, 2016 8:18 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You can specify no dates or both dates, but not just one date...

If you're just looking for YTD numbers, try something like:

=RCHGetYahooHistory("^GSPC",2016,1,4,2016,12,31,"w","dA",,,1)

Then it will just give you what's available for the range of the two dates.

On Mon, Oct 24, 2016 at 3:54 AM, pc_babe@
​... wrote:

>
> Im trying to use the yahoo historical array. I'd like the start date to
> begin with this calendar year from Jan 4, 2016 ...and wrote:
>
> =
> ​​
> RCHGetYahooHistory("^GSPC";,2016,01,04,,,,"w","dA",,,1)
>
> But, the comment comes with "problems with start date". If I leave the
> dats switches empty, it works fine, but provides data to the size of the
> array
>
> Do you have a suggestion?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar