Senin, 15 Agustus 2016

[smf_addin] Digest Number 3772[1 Attachment]

15 Messages

Digest #3772
3b
Re: Mutual Fund data / attributes by "Randy Harmelink" rharmelink
4a
4b
4c
5b
Re: Occasional Incomplete Yahoo Data by "Randy Harmelink" rharmelink
5d
Re: Occasional Incomplete Yahoo Data by "Randy Harmelink" rharmelink

Messages

Sun Aug 14, 2016 6:27 am (PDT) . Posted by:

sjagers

I appreciate your help. Thank you very much. I'll give it a try.

Sun Aug 14, 2016 5:50 pm (PDT) . Posted by:

sjagers

Randy... Before I try the timer portion of your suggestion, I thought I'd test your VBA code to simply import historical prices for a symbol (GDX, for example) to a new worksheet in a workbook. Here's the code I'm using:

Sub importGDX()

Call smfForceRecalculation
Sheets.Add Type:="Worksheet"
ActiveSheet.Range("B2").Resize(100, 50).Value = smfGetCSVFIle("http://www.google.com/finance/historical?q=NYSE%3AGDX&ei=4fawV7iiJouxjAGCyrewDA&output=csv", pDim1:=100, pDim2:=50)

End Sub


When I run the above code in your "RCHGetYahooQuotes-Example-Timed-Update.xls" workbook, it works great!

But when I run the code in a new, blank .xlsm (Office 2007) workbook, I get a "compile error" on the user-defined functions: smfForceRecalculation, smfGetCSVFile...... as if they are not defined. (Error snapshot attached).

Any idea why smfForceRecalculation and smfGetCSVFile are recognized in VBA in your downloaded "xls" file, but not in my "xlsm" file? Both your file and my file are in the same location on my PC (my desktop) and all of your SMF Add-In functions seem to work properly in all of my other .xlsm files.
Thanks.
Steve
Attachment(s) from
1 of 1 Photo(s)

Sun Aug 14, 2016 6:00 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You need to use the "> Tools > References" menu in the VBA project to tag
the SMF add-in library as a reference for the VBA project. That makes all
of its macros and subroutines available to the VBA project.

On Sun, Aug 14, 2016 at 5:50 PM, sjagers@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Randy... Before I try the timer portion of your suggestion, I thought I'd
> test your VBA code to simply import historical prices for a symbol (GDX,
> for example) to a new worksheet in a workbook. Here's the code I'm using:
>
> Sub importGDX()
>
> Call smfForceRecalculation
> Sheets.Add Type:="Worksheet"
> ActiveSheet.Range("B2").Resize(100, 50).Value = smfGetCSVFIle("
> http://www.google.com/finance/historical?q=NYSE%3AGDX&ei=
> 4fawV7iiJouxjAGCyrewDA&output=csv", pDim1:=100, pDim2:=50)
>
> End Sub
>
>
> When I run the above code in your "RCHGetYahooQuotes-Example-Timed-Update.xls"
> workbook, it works great!
>
> But when I run the code in a new, blank .xlsm (Office 2007) workbook, I
> get a "compile error" on the user-defined functions:
> smfForceRecalculation, smfGetCSVFile...... as if they are not defined.
> (Error snapshot attached).
>
> Any idea why smfForceRecalculation and smfGetCSVFile are recognized in VBA
> in your downloaded "xls" file, but not in my "xlsm" file? Both your file
> and my file are in the same location on my PC (my desktop) and all of your
> SMF Add-In functions seem to work properly in all of my other .xlsm files.
>

Sun Aug 14, 2016 6:47 pm (PDT) . Posted by:

sjagers

Ahhhhh, Eureka, I should have known! I'm a dummy. The test VBA works now! Thanks for your help.

Sun Aug 14, 2016 6:53 am (PDT) . Posted by:

krisha_mehta

I have the same problem, noticed since last few weeks. I tried the same suggestion and it works!!

Any permanent resolution?

Sun Aug 14, 2016 7:01 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hard for anyone to know what you're talking about, as you give no context.
Many suggestions were offered.

If you're referring to the "unblock" fix, it was a workaround suggested by
Microsoft, until they apply a permanent solution.

On Sun, Aug 14, 2016 at 6:53 AM, krisha_mehta@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I have the same problem, noticed since last few weeks. I tried the same
> suggestion and it works!!
>
> Any permanent resolution?
>
>

Sun Aug 14, 2016 8:13 am (PDT) . Posted by:

msimmsx

http://finance.yahoo.com/quote/BPTRX?p=BPTRX http://finance.yahoo.com/quote/BPTRX?p=BPTRX
I want to fetch all attributes like ratings, beta, yield, expense ratio, etc. from the above listing.
What's the best approach using the function library ?



Sun Aug 14, 2016 8:22 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Either RCHGetTableCell() or smfGetTagContent() would be best. For example:

=smfGetTagContent("http://finance.yahoo.com/quote/BPTRX
> ","td",1,">Beta",,,,1)
>

​Or you get could everything at once with by array-entering this over a
range:

=RCHGetHTMLTable("http://finance.yahoo.com/quote/BPTRX",">Prev Close",,,2)​

On Sun, Aug 14, 2016 at 8:13 AM, marksimms@
​...wrote:

>
> http://finance.yahoo.com/quote/BPTRX?p=BPTRX
> I want to fetch all attributes like ratings, beta, yield, expense ratio,
> etc. from the above listing.
> What's the best approach using the function library ?
>

Sun Aug 14, 2016 8:23 am (PDT) . Posted by:

aadkruit@ymail.com

As from July 22nd the ISIN-code for ING has been changed by EURONEXT; viz. from NL0000303600 into NL0011821202.

Since you mentioned quotes history I guess the merger of the two ISIN-codes hasn't been applied in the YH quotes database yet.

Euronext.com provides download facility for quote history in csv format.

I hope this will be useful in solving the matter.

Aad

Mon Aug 15, 2016 1:20 am (PDT) . Posted by:

aadkruit@ymail.com

As from July 22nd the ISIN-code for ING has been changed by EURONEXT; viz. from NL0000303600 into NL0011821202.

Since you mentioned quotes history I guess the merger of the two ISIN-codes hasn't been applied in the YH quotes database yet.

Euronext.com provides download facility for quote history in csv format.
I hope this will be useful in solving the matter.

Aad

Mon Aug 15, 2016 1:37 am (PDT) . Posted by:

aadkruit@ymail.com

As from July 22nd the ISIN-code for ING has been changed by EURONEXT; viz. from NL0000303600 into NL0011821202.

Since you mentioned quotes history I guess the merger of the two ISIN-codes hasn't been applied in the YH quotes database yet.

Euronext.com provides download facility for quote history in csv format.
I hope this will be useful in solving the matter.

Aad

Sun Aug 14, 2016 3:29 pm (PDT) . Posted by:

sonofhercules

Hey Randy -


Thanks as always for the gift that is RCHGetYahooHistory add-in! I use it to get OHLCV data for the Nasdaq 100.


This past Friday (August 12, 2016) I noticed that some of the constituent data could not be pulled in through the function. Although I could view the Yahoo Finance historical data tab at their site and see the posting of OHLCV data for the constituent, it has not been downloaded by the RCH function, and I have been trying all weekend. Thursday, August 11th data and prior have no problems.


In the past, if Yahoo had not updated their historical data, then the function could not pull in the data and it would also not be available for viewing on that section of their site. Typically Yahoo would have the data available at a later time, and all would be good.


Any thoughts on this? For a RCH download that I just attempted on the Nasdaq 100, I am missing data for the constituents AVGO, CHTR, NXPI, TRIP, TSLA, and VRSK.


Regards,
SoH.

Sun Aug 14, 2016 4:25 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hopefully just a temporary glitch on Yahoo's part. Keep in mind that just
seeing the data displayed doesn't really mean anything. You need to try the
"Download Data" link. That's the CSV file that the add-in uses. I just
looked at another ticker symbol yesterday that someone was having a problem
with. It displayed the historical quotes data, but if I clicked on the
"Download Data" link, Yahoo gave me a "404" error -- page not found.

I just tried all six tickers you list below, and they all worked fine here.

On Sun, Aug 14, 2016 at 3:29 PM, sonofhercules@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks as always for the gift that is RCHGetYahooHistory add-in! I use it
> to get OHLCV data for the Nasdaq 100.
>
> This past Friday (August 12, 2016) I noticed that some of the constituent
> data could not be pulled in through the function. Although I could view
> the Yahoo Finance historical data tab at their site and see the posting of
> OHLCV data for the constituent, it has not been downloaded by the RCH
> function, and I have been trying all weekend. Thursday, August 11th data
> and prior have no problems.
>
> In the past, if Yahoo had not updated their historical data, then the
> function could not pull in the data and it would also not be available for
> viewing on that section of their site. Typically Yahoo would have the data
> available at a later time, and all would be good.
>
> Any thoughts on this? For a RCH download that I just attempted on the
> Nasdaq 100, I am missing data for the constituents
> ​​
> AVGO, CHTR, NXPI, TRIP, TSLA, and
> ​​
> VRSK.
>

Sun Aug 14, 2016 5:23 pm (PDT) . Posted by:

sonofhercules

Interesting; I just used successfully the Yahoo "Download Data" option on AVGO, but when I opened the CSV file, only data up to Thursday, August 11th is in the file, even though the web page visually shows data up to and including August 12th.


The situation is the same with CHTR, NXPI, TRIP, TSLA, and VRSK.


May I ask: Are you saying your RCH function worked fine, or that the Yahoo Download Data CSV function worked fine?


Acknowledged that, as with all things free, hopefully this is just a temporary Yahoo glitch! :-)




Sun Aug 14, 2016 5:43 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I tried the RCHGetYahooHistory() function on each, but I only gathered a
few rows of data, and didn't really look at it. I was just trying to
confirm whether or not data was being retrieved. I misunderstood your first
message when you said data wasn't coming through...

So, definitely a Yahoo problem.

On Sun, Aug 14, 2016 at 5:23 PM, sonofhercules@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Interesting; I just used successfully the Yahoo "Download Data" option on
> AVGO, but when I opened the CSV file, only data up to Thursday, August 11th
> is in the file, even though the web page visually shows data up to and
> including August 12th.
>
> The situation is the same with CHTR, NXPI, TRIP, TSLA, and VRSK.
>
> May I ask: Are you saying your RCH function worked fine, or that the
> Yahoo Download Data CSV function worked fine?
>
> Acknowledged that, as with all things free, hopefully this is just a
> temporary Yahoo glitch! :-)
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 01.37

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)