15 Messages
Digest #3782
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.
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(
smfPricesByDates(
smfPricesByDates(
smfPricesByDates(
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.
>
>
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(
>
> smfPricesByDates(
>
> smfPricesByDates(
>
> smfPricesByDates(
>
> 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.
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(
Yahoo adj close is 34.11
smfPricesByDates(
Yahoo adj close is 20.67
smfPricesByDates(
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.
>
>
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(
> Yahoo adj close is 34.11
> smfPricesByDates(
> Yahoo adj close is 20.67
>
> smfPricesByDates(
> 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 ?
>
>
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
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"
The only way to get the formulas to work is to click "Don'
What is interesting is that every time I click Browse, it takes me to the following file destination: Users>Me>
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?
>
>
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"
> get a #NAME? error.
>
> The only way to get the formulas to work is to click "Don'
> then manually go to the add-in menu via File>>
> Excel Add-ins>>
> item and click Browse, then re-linking to the RCH_Stock_Market_
> 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>
> 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.
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.
>
"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","
> 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
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.
>
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.
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
>
>
>
>
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:
Posting Komentar