Sabtu, 25 April 2015

[smf_addin] Digest Number 3391

6 Messages

Digest #3391
2a
Re: ADVFN fail? by bikeflagaz
2b
Re: ADVFN fail? by "Randy Harmelink" rharmelink
2c
Re: ADVFN fail? by bikeflagaz

Messages

Fri Apr 24, 2015 1:56 am (PDT) . Posted by:

"Pete Guy" yvrflyguy

OK, thanks Randy.
Is there any comparable method to smfGetCSVFile() that will work for .xls files?
For example:
http://www.cboe.com/micro/buywrite/dailypricehistory.xls
or:
https://us.spindices.com/idsexport/file.xls?hostIdentifier=48190c8c-42c4-46af-8d1a-0cd5db894797&selectedModule=PerformanceGraphView&selectedSubModule=Graph&yearFlag=fiveYearFlag&indexId=11000451
Thanks again for any suggestions,
Peter

To: smf_addin@yahoogroups.com
From: smf_addin@yahoogroups.com
Date: Wed, 22 Apr 2015 23:42:01 -0700
Subject: Re: [smf_addin] Retrieving historical .xls data file from nasdaq.com

Sorry, but I don't see a way to do it with the add-in. It doesn't really grab a file that's sitting on the Internet anywhere. It appears to use JSON to create the file on the fly.

You would probably need VBA code that interacts with the IE object to do the task.

On Wed, Apr 22, 2015 at 9:59 PM, a330pete@hotmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Does anybody have any experience with retrieving the data from the .xls file link at the bottom of a nasdaq.com historical price & volume page?

For example:

iPath S&P 500 VIX Short Term Futures ETN (VXX) Historical Prices & Data - NASDAQ.com

iPath S&P 500 VIX Short Term Futures ETN (VXX) Historica... VXX historical prices, VXX historical data,iPath S&P 500 VIX Short Term Futures ETN historical prices, historical stock prices, historical prices, historica... View on www.nasdaq.com Preview by Yahoo

I'd like to retrieve the data in a similar way to using the smfGetCSVFile() function, but the link is javascript and I can't find a suitable link reference in the page code to do this.

Any suggestions?

Fri Apr 24, 2015 8:02 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You don't need the add-in to grab data from an XLS file that exists on the
Internet. It's a normal EXCEL process. See:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/22983

For example:

='http://www.cboe.com/micro/buywrite/[dailypricehistory.xls]Daily'!A1

It won't work for the second one because that's not a file sitting out
there. The URL is an export process that creates the XLS file that
eventually gets downloading.

On Fri, Apr 24, 2015 at 1:56 AM, Pete Guy a330pete@hotmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> OK, thanks Randy.
>
> Is there any comparable method to smfGetCSVFile() that will work for .xls
> files?
>
> For example:
>
> http://www.cboe.com/micro/buywrite/dailypricehistory.xls
>
> or:
>
>
> https://us.spindices.com/idsexport/file.xls?hostIdentifier=48190c8c-42c4-46af-8d1a-0cd5db894797&selectedModule=PerformanceGraphView&selectedSubModule=Graph&yearFlag=fiveYearFlag&indexId=11000451
>
>
>

Fri Apr 24, 2015 9:38 am (PDT) . Posted by:

bikeflagaz

Bump.

At this time, none of the =RCHGetElementNumber() data items are working for me, regardless of the data source they use.
Is anyone else having any success?

Fri Apr 24, 2015 9:54 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Are you using the latest release of the add-in, from the "Works in
Progress" folder of the web site? I had to make changes to the add-in in
March because of AdvFN web page changes:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/28118

On Fri, Apr 24, 2015 at 9:38 AM, bikeflagaz@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> At this time, none of the =RCHGetElementNumber() data items are working
> for me, regardless of the data source they use.
> Is anyone else having any success?
>

Fri Apr 24, 2015 2:01 pm (PDT) . Posted by:

bikeflagaz

That did the trick. Thanks for pointing it out.

Fri Apr 24, 2015 10:15 am (PDT) . Posted by:

dcrapo

Has anyone found a way to get dividend yields/amounts in in array for Canadian stocks? Yahoo Finance has not provided this data for a few weeks.


For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar