Rabu, 24 Agustus 2016

[smf_addin] Digest Number 3782

15 Messages

Digest #3782
1b
Re: Incorrect Adj Close using smfPricesByDates by "Randy Harmelink" rharmelink
2b
Re: Problems with Yahoo historical quotes by "Randy Harmelink" rharmelink
2d
Re: Problems with Yahoo historical quotes by "Randy Harmelink" rharmelink
3a
3b
Re: Add-in Glitch In Excel by "Randy Harmelink" rharmelink
4b
Re: Mutual Fund data / attributes by "Randy Harmelink" rharmelink
5a
5b
Re: Microsoft Excel security message by "Randy Harmelink" rharmelink
5c
Re: Microsoft Excel security message by "D. Scott MacKenzie" kb0fhp
5d
Re: Microsoft Excel security message by "Randy Harmelink" rharmelink

Messages

Wed Aug 24, 2016 7:56 am (PDT) . Posted by:

austinramesh

Thanks Randy for the Add-in. New user. I appreciate your work.


Is this a bug ?


I am using Excel 2010 on Windows 7 and I see price discrepancy between yahoo adjusted quotes and the smfPricesByDates




examples:
smfPricesByDates("MO", DATE(2010,5,20)) gives 15.07 , Yahoo price is 20.67

smfPricesByDates("MO", DATE(2014,2,3)) gives 30.69, Yahoo price is 34.11

smfPricesByDates("ACC", DATE(2013,5,22)) gives 38.34, Yahoo price is 43.53

smfPricesByDates("EMR", DATE(2015,9,3)) gives 42.05 , Yahoo price is 46.43

I can provide more examples if needed.

Wed Aug 24, 2016 8:34 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It is a bug. From Yahoo. :(

I assume you're looking at the historical quotes web pages? They are
incorrect. They are showing the actual closing prices only and not showing
any adjusted closing prices. For example, this is from the "Download Data"
CSV file for MO:

Date Open High Low Close Volume Adj Close
5/20/2010 21.09 21.1 20.67 20.67 23402100 15.067891
​So $20.67 was the actual closing price and $15.07​ is the adjusted closing
price.

On Wed, Aug 24, 2016 at 7:43 AM, austinramesh@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Thanks Randy for the Add-in. New user. I appreciate your work.
>
> Is this a bug ?
>
> I am using Excel 2010 on Windows 7 and I see price discrepancy between
> yahoo adjusted quotes and the smfPricesByDates
>
> examples:
>
> smfPricesByDates("MO", DATE(2010,5,20)) gives 15.07 , Yahoo price is 20.67
>
> smfPricesByDates("MO", DATE(2014,2,3)) gives 30.69, Yahoo price is 34.11
>
> smfPricesByDates("ACC", DATE(2013,5,22)) gives 38.34, Yahoo price is 43.53
>
> smfPricesByDates("EMR", DATE(2015,9,3)) gives 42.05 , Yahoo price is 46.43
>
> I can provide more examples if needed.
>
>

Wed Aug 24, 2016 7:57 am (PDT) . Posted by:

austinramesh

New user. Thank you Randy for your EXCEL add-in functions. Appreciate it very much.

I don't know if this is a temporary glitch but I see results not consistent with Yahoo quotes.


I am using Excel 2010 on a Windows 7.


Examples:
smfPricesByDates("MO", DATE(2014,2,3) gives 30.69

Yahoo adj close is 34.11
smfPricesByDates("MO", DATE(2010,5,20) gives 15.07

Yahoo adj close is 20.67


smfPricesByDates("ACC", DATE(2013,5,22)) gives 38.34

Yahoo adj close is 43.53


I can provide more examples if needed.

Wed Aug 24, 2016 8:13 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

See the other message. The Yahoo historical quotes web pages aren't
consistent with the CSV file. The CSV file looks correct.

BTW, you aren't getting those MO prices individually, are you? You can cut
down your retrieval time by getting them all at once with an array-entered
formula. There's an Internet access for each invocation of the formula.

On Wed, Aug 24, 2016 at 7:50 AM, austinramesh@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> New user. Thank you Randy for your EXCEL add-in functions. Appreciate it
> very much.
>
> I don't know if this is a temporary glitch but I see results not
> consistent with Yahoo quotes.
>
> I am using Excel 2010 on a Windows 7.
>
> Examples:
> smfPricesByDates("MO", DATE(2014,2,3) gives 30.69
> Yahoo adj close is 34.11
> smfPricesByDates("MO", DATE(2010,5,20) gives 15.07
> Yahoo adj close is 20.67
>
> smfPricesByDates("ACC", DATE(2013,5,22)) gives 38.34
> Yahoo adj close is 43.53
>
> I can provide more examples if needed.
>
>

Wed Aug 24, 2016 8:16 am (PDT) . Posted by:

austinramesh

Thanks Randy. You are correct . Seems like Yahoo web prices are incorrect and csv is correct. When will yahoo ever get their act together ?

Wed Aug 24, 2016 8:25 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Too late now -- Verizon is ending their struggle.

Hopefully, our won't be getting worse...

On Wed, Aug 24, 2016 at 8:16 AM, austinramesh@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks Randy. You are correct . Seems like Yahoo web prices are incorrect
> and csv is correct. When will yahoo ever get their act together ?
>
>

Wed Aug 24, 2016 9:12 am (PDT) . Posted by:

bkipersztok

Hello -


I am having issues with the add-in. I have a spreadsheet that utilizes the add-in extensively, but it doesn't start pulling the data until I activate the formulas with a "Y/N" command in a separate cell (which activates the formulas via an "If" statement).


Every time I open the spreadsheet, I get a message stating "This workbook contains links to one or more external sources that could be unsafe. If you trust the links, update them to get the latest data. Otherwise, you can keep working with the data you have."


The pop-up offers three choices: Update, Don't Update, and Help. If I click "Update", then when I activate the formulas with the "Y" command, I get a #NAME? error.


The only way to get the formulas to work is to click "Don't Update", and then manually go to the add-in menu via File>>Options>>Add-ins>>Manage Excel Add-ins>>Go, then click on the Stock Market Functions Add-in line item and click Browse, then re-linking to the RCH_Stock_Market_Functions XLA file I have in a folder on my desktop.


What is interesting is that every time I click Browse, it takes me to the following file destination: Users>Me>AppData>Roaming>Microsoft>AddIns rather than going to the file location on my desktop that I have to re-link to every time.


Is there a way around having to re-link to the XLA file every time I open this document? Does anyone know a fix to this issue?


Thanks,


Billy




Wed Aug 24, 2016 9:18 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

This has been discussed in a number of message threads recently. The
problem appears to be related to a recent MicroSoft security update.

It's not letting EXCEL load the add-in when EXCEL starts up. As a result,
you are getting link errors, because EXCEL can't resolve the links to the
add-in.

For a workaround suggested by Microsoft, until they fix the issue, see:

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

On Wed, Aug 24, 2016 at 9:12 AM, bkipersztok@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I am having issues with the add-in. I have a spreadsheet that utilizes the
> add-in extensively, but it doesn't start pulling the data until I activate
> the formulas with a "Y/N" command in a separate cell (which activates the
> formulas via an "If" statement).
>
> Every time I open the spreadsheet, I get a message stating "This workbook
> contains links to one or more external sources that could be unsafe. If you
> trust the links, update them to get the latest data. Otherwise, you can
> keep working with the data you have."
>
> The pop-up offers three choices: Update, Don't Update, and Help. If I
> click "Update", then when I activate the formulas with the "Y" command, I
> get a #NAME? error.
>
> The only way to get the formulas to work is to click "Don't Update", and
> then manually go to the add-in menu via File>>Options>>Add-ins>>Manage
> Excel Add-ins>>Go, then click on the Stock Market Functions Add-in line
> item and click Browse, then re-linking to the RCH_Stock_Market_Functions
> XLA file I have in a folder on my desktop.
>
> What is interesting is that every time I click Browse, it takes me to the
> following file destination: Users>Me>AppData>Roaming>Microsoft>AddIns
> rather than going to the file location on my desktop that I have to re-link
> to every time.
>
> Is there a way around having to re-link to the XLA file every time I open
> this document? Does anyone know a fix to this issue?
>
>

Wed Aug 24, 2016 9:42 am (PDT) . Posted by:

bkipersztok

Thanks Randy. Got it. Apologies for not noticing the prior thread.

Wed Aug 24, 2016 6:34 pm (PDT) . Posted by:

msimmsx

re: "=smfGetTagContent("http://finance.yahoo.com/quote/BPTRX http://finance.yahoo.com/quote/BPTRX","span",1,">Fund Summary")"

This did not work at all.....I just got a massive amount of undecipherable HTML....and no real data.
Could it be due to my 2011 edition of the add-in ?
I'm going to upgrade tomorrow.

Wed Aug 24, 2016 7:46 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. Just tried it again here, and I get:

"The investment seeks capital appreciation. The fund invests for the long
term primarily in equity securities in the form of common stock of U.S.
growth companies of any size. The Adviser seeks to invest in businesses the
advisor believes have significant opportunities for growth, sustainable
competitive advantages, exceptional management, and an attractive
valuation. To take advantage of opportunities to invest, the fund may
borrow money from banks (leverage) in an amount up to one-third of its
total assets, which include assets purchased with borrowed money. It is
non-diversified."

But. yeah, a lot of changes in 5 years... :)

Hope that fixes the problem.

On Wed, Aug 24, 2016 at 6:34 PM, marksimms@
​...wrote:

>
> re: "=smfGetTagContent("http://finance.yahoo.com/quote/BPTRX","span",1,">Fund
> Summary")"
>
> This did not work at all.....I just got a massive amount of undecipherable
> HTML....and no real data.
> Could it be due to my 2011 edition of the add-in ?
> I'm going to upgrade tomorrow.
>

Wed Aug 24, 2016 7:11 pm (PDT) . Posted by:

"Leo Bueno" leobueno

I don't see the "Trusted" option in the Properties for any of the worksheets. I am using Window 7, Excel 2010.

Leo Bueno
305-669-5260
1825 Ponce de Leon Boulevard # 483
Coral Gables, FL 33134
Leo@BuenoLaw.com
Skype: BuenoLaw

[cid:image001.png@01D1E033.9E0A3CC0]



From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Thursday, July 28, 2016 12:27 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Microsoft Excel security message



Randy:

Adding the Trusted Location works perfectly. Maybe add that step to the installation instructions.

Thank for everything you do.

NM

Wed Aug 24, 2016 7:48 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's not a worksheet property. You designate a hard drive folder as a
trusted location. As Microsoft notes, unblocking is a better way to go. See:

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

On Wed, Aug 24, 2016 at 6:56 PM, Leo Bueno Leo@BuenoLaw.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I don't see the "Trusted" option in the Properties for any of the
> worksheets. I am using Window 7, Excel 2010.
>

Wed Aug 24, 2016 8:01 pm (PDT) . Posted by:

"D. Scott MacKenzie" kb0fhp

I didn't see the unlocking option

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, August 24, 2016 10:49 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Microsoft Excel security message

It's not a worksheet property. You designate a hard drive folder as a trusted location. As Microsoft notes, unblocking is a better way to go. See:

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

On Wed, Aug 24, 2016 at 6:56 PM, Leo Bueno Leo@BuenoLaw.com <mailto:Leo@BuenoLaw.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

I don't see the "Trusted" option in the Properties for any of the worksheets. I am using Window 7, Excel 2010.

Wed Aug 24, 2016 8:20 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Un*b*lock. I thought they started that with Windows 7. I only have Vista,
so it doesn't exist on my machine.

Otherwise, that reference also indicated how to trust a location.

On Wed, Aug 24, 2016 at 8:01 PM, 'D. Scott MacKenzie' kb0fhp@v
​...​
wrote:

>
> I didn't see the unlocking option
>
>
>
> *From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *Sent:* Wednesday, August 24, 2016 10:49 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] Microsoft Excel security message
>
>
>
>
>
> It's not a worksheet property. You designate a hard drive folder as a
> trusted location. As Microsoft notes, unblocking is a better way to go. See:
>
> https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar