4 Messages
Digest #3825
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?
>
>
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?
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
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?
>
If you're just looking for YTD numbers, try something like:
=RCHGetYahooHistory
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(
>
> 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:
Posting Komentar