6 Messages
Digest #3391
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?
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(
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
>
>
>
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?
At this time, none of the =RCHGetElementNumbe
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?
>
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 =RCHGetElementNumbe
> 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:
Posting Komentar