15 Messages
Digest #4205
Messages
Fri Nov 3, 2017 8:33 pm (PDT) . Posted by:
jimmymc00
Bruce. I assume you are looking for the %chg for last price. You can calculate it from using the Last Price and Change amounts returned by the add-in. In a separate cell outside the array the formula would look something like this:
=(last price-(last price-change))/(last price-change)
You can format the cell for a %.
-----Original Message-----
From: bobobfd@yahoo.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Fri, Nov 3, 2017 8:43 pm
Subject: [smf_addin] New parameter for =smfGetYahooPortfol
Hi Randy,
any way to add "% Chg" to the parameter list?
Thanks ~ Bruce
Sat Nov 4, 2017 12:17 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Or just:
=change/(last price-change)
...since (last price-last price) would always be zero.
On Fri, Nov 3, 2017 at 8:33 PM, jmcatee133@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Bruce. I assume you are looking for the %chg for last price. You can
> calculate it from using the Last Price and Change amounts returned by the
> add-in. In a separate cell outside the array the formula would look
> something like this:
>
> =(last price-(last price-change))/(last price-change)
>
> You can format the cell for a %.
>
=change/(last price-change)
...since (last price-last price) would always be zero.
On Fri, Nov 3, 2017 at 8:33 PM, jmcatee133@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Bruce. I assume you are looking for the %chg for last price. You can
> calculate it from using the Last Price and Change amounts returned by the
> add-in. In a separate cell outside the array the formula would look
> something like this:
>
> =(last price-(last price-change)
>
> You can format the cell for a %.
>
Sat Nov 4, 2017 12:29 am (PDT) . Posted by:
"Robbie Geary" rgearyiii
These formulas *should* hold true, but in rare cases where they don't, they
alert one to problems in Yahoo!'s data.
On Sat, Nov 4, 2017 at 6:17 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> Or just:
>
> =change/(last price-change)
>
> ...since (last price-last price) would always be zero.
>
> On Fri, Nov 3, 2017 at 8:33 PM, jmcatee133@aol.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>>
>> Bruce. I assume you are looking for the %chg for last price. You can
>> calculate it from using the Last Price and Change amounts returned by the
>> add-in. In a separate cell outside the array the formula would look
>> something like this:
>>
>> =(last price-(last price-change))/(last price-change)
>>
>> You can format the cell for a %.
>>
>
>
--
Robbie Geary
alert one to problems in Yahoo!'s data.
On Sat, Nov 4, 2017 at 6:17 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> Or just:
>
> =change/(last price-change)
>
> ...since (last price-last price) would always be zero.
>
> On Fri, Nov 3, 2017 at 8:33 PM, jmcatee133@aol.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>>
>> Bruce. I assume you are looking for the %chg for last price. You can
>> calculate it from using the Last Price and Change amounts returned by the
>> add-in. In a separate cell outside the array the formula would look
>> something like this:
>>
>> =(last price-(last price-change)
>>
>> You can format the cell for a %.
>>
>
>
--
Robbie Geary
Fri Nov 3, 2017 9:34 pm (PDT) . Posted by:
option2z
...
Me too! Thanks Randy
RE:
just set my account to FFRF.
Best regards,
Ernie
Me too! Thanks Randy
RE:
just set my account to FFRF.
Best regards,
Ernie
Fri Nov 3, 2017 9:56 pm (PDT) . Posted by:
"Home" SUNIL_M_DHOOT
It is working perfectly today. There was a ticker symbol problem. Some of the companies did not exist anymore. The value returned is —.
I had originally requested values for about 200 stocks. I do not know if this is important. I now changed to requesting values for 40 ticker symbols at a time. This seems to work.
Thank you.
Sunil Dhoot
Sent from my iPhone
> On Nov 3, 2017, at 2:43 AM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Which ticker symbols are you having problems with?
>
> I've seen two situations for skipping:
>
> 1. Not a valid ticker symbol
> 2. Non-US currency combination (i.e. CADAUD=X). This is fixed for the next release.
>
> On Thu, Nov 2, 2017 at 9:22 PM, Home sdhoot@
> ...
> wrote:
>>
>> I downloaded the latest addin and then used the following
>> =smfgetyahooportfolioview(b6:b188,"0115",,1)
>> Where column B has the ticker symbols. This returns the ticker symbol and value.
>>
>> This works well except occasionally it skips some ticker symbols and goes to the next one.
>>
>> What is causing some ticker symbols to skip?
>>
>
>
I had originally requested values for about 200 stocks. I do not know if this is important. I now changed to requesting values for 40 ticker symbols at a time. This seems to work.
Thank you.
Sunil Dhoot
Sent from my iPhone
> On Nov 3, 2017, at 2:43 AM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Which ticker symbols are you having problems with?
>
> I've seen two situations for skipping:
>
> 1. Not a valid ticker symbol
> 2. Non-US currency combination (i.e. CADAUD=X). This is fixed for the next release.
>
> On Thu, Nov 2, 2017 at 9:22 PM, Home sdhoot@
> ...
> wrote:
>>
>> I downloaded the latest addin and then used the following
>> =smfgetyahooportfol
>> Where column B has the ticker symbols. This returns the ticker symbol and value.
>>
>> This works well except occasionally it skips some ticker symbols and goes to the next one.
>>
>> What is causing some ticker symbols to skip?
>>
>
>
Fri Nov 3, 2017 10:14 pm (PDT) . Posted by:
nelsonmuntz1000
See my post 33419 for the math on the date code. Randy's UNIX formulas didn't work for me as my computer is setup for UK dates, not US dates.
Sat Nov 4, 2017 12:21 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Why would UK vs US make a difference? UNIX date/time values are the number
of seconds since the start of 1970 and EXCEL serial data/time value are the
number of days since the start of 1900. The difference between UK and US is
formatting of dates, not their underlying numeric values.
On Fri, Nov 3, 2017 at 10:14 PM, ccoupe300@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> See my post 33419 for the math on the date code. Randy's UNIX formulas
> didn't work for me as my computer is setup for UK dates, not US dates.
>
>
>
of seconds since the start of 1970 and EXCEL serial data/time value are the
number of days since the start of 1900. The difference between UK and US is
formatting of dates, not their underlying numeric values.
On Fri, Nov 3, 2017 at 10:14 PM, ccoupe300@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> See my post 33419 for the math on the date code. Randy's UNIX formulas
> didn't work for me as my computer is setup for UK dates, not US dates.
>
>
>
Sat Nov 4, 2017 7:07 am (PDT) . Posted by:
nelsonmuntz1000
Yep, you're right. Thought I got a different result when I first tested it. Have had issues before when tring to convert dates. =smfUNIX2Date() works great.
Sat Nov 4, 2017 8:43 am (PDT) . Posted by:
sarichead
After hours of working on this, the best work-around I found is to use Google sheets to look up all your stock prices with =GOOGLEFINANCE($A4,"price") where your list of tickers is in column A, (or whatever you want). Then save it to google drive where, by nature, it is a web page. Then use excel to get external data. Use the "legacy web wizard" to import the data of the sheet you just saved. The url is the copy/paste url from the google sheet in google drive. Excel's browser is IE(some version that is out of date) but it will still import the data (looks a little Krazy, but it is consistent). The cool thing is that if you are using a macro to do the refresh it will access the google sheets document, and when doing so update the cells and import the current values into excel. in the data properties, un-check the background refresh. This will allow the sheet to update before moving on. hopefully this helps some one.
Sat Nov 4, 2017 12:13 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
At this point, RCHGetYahooQuotes() is dead. Yahoo has unplugged the current
quotes CSV file that it got its data from. See recent announcements on the
blog concerning a replacement:
https://smf-add-in.blogspot.com/
On Fri, Nov 3, 2017 at 6:44 PM, ada95054@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> The following message is now displayed when on that URL
> <https://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1&e=.ignore>
> :
>
> It has come to our attention that this service is being used in violation
> of the Yahoo Terms of Service. As such, the service is being discontinued.
> For all future markets and equities data research, please refer to
> finance.yahoo.com.
>
> Does it mean that the SMF Add-In will never work again?
>
>
quotes CSV file that it got its data from. See recent announcements on the
blog concerning a replacement:
https://smf-add-in.blogspot.com/
On Fri, Nov 3, 2017 at 6:44 PM, ada95054@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> The following message is now displayed when on that URL
> <https://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1&e=.ignore>
> :
>
> It has come to our attention that this service is being used in violation
> of the Yahoo Terms of Service. As such, the service is being discontinued.
> For all future markets and equities data research, please refer to
> finance.yahoo.
>
> Does it mean that the SMF Add-In will never work again?
>
>
Sat Nov 4, 2017 2:39 am (PDT) . Posted by:
"V. Shankar" tarakayan
Version 2.1.20017.10.24; win 32 bit
Sent from my iPhone
> On 03-Nov-2017, at 10:40 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Which version of the add-in are you using?
>
> =RCHGetElementNumber("Version")
>
> What are your first half-dozen tickers? Does it work OK just with them?
>
>> On Fri, Nov 3, 2017 at 9:21 AM, 'V. Shankar' tarakayan@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>>
>> The same spreadsheet with smfGetYahooPortfolioView function was working fine earlier in the day...now only for the first 2 rows, it returned all values...I have around 135 US stock symbols in this spreadsheet. anything I am missing?
>>
>
>
Sent from my iPhone
> On 03-Nov-2017, at 10:40 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Which version of the add-in are you using?
>
> =RCHGetElementNumber("Version")
>
> What are your first half-dozen tickers? Does it work OK just with them?
>
>> On Fri, Nov 3, 2017 at 9:21 AM, 'V. Shankar' tarakayan@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>>
>> The same spreadsheet with smfGetYahooPortfoli
>>
>
>
Sat Nov 4, 2017 2:42 am (PDT) . Posted by:
"V. Shankar" tarakayan
Sorry there is no internet now....will try after a while and get back...how come smfgeryahooporfolioview is able to get data when rchgetyahooquotes stopped?
Sent from my iPhone
> On 03-Nov-2017, at 10:40 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Which version of the add-in are you using?
>
> =RCHGetElementNumber("Version")
>
> What are your first half-dozen tickers? Does it work OK just with them?
>
>> On Fri, Nov 3, 2017 at 9:21 AM, 'V. Shankar' tarakayan@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>>
>> The same spreadsheet with smfGetYahooPortfolioView function was working fine earlier in the day...now only for the first 2 rows, it returned all values...I have around 135 US stock symbols in this spreadsheet. anything I am missing?
>>
>
>
Sent from my iPhone
> On 03-Nov-2017, at 10:40 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Which version of the add-in are you using?
>
> =RCHGetElementNumber("Version")
>
> What are your first half-dozen tickers? Does it work OK just with them?
>
>> On Fri, Nov 3, 2017 at 9:21 AM, 'V. Shankar' tarakayan@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>>
>> The same spreadsheet with smfGetYahooPortfoli
>>
>
>
Sat Nov 4, 2017 2:57 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You may need the most recent version of the add-in.
On Sat, Nov 4, 2017 at 2:38 AM, 'V. Shankar' tarakayan@
...
wrote:
>
> Version 2.1.20017.10.24; win 32 bit
>
> On 03-Nov-2017, at 10:40 PM, Randy Harmelink rharmelink@gmail.com
> [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Which version of the add-in are you using?
>
> =RCHGetElementNumber("Version")
>
> What are your first half-dozen tickers? Does it work OK just with them?
>
> On Fri, Nov 3, 2017 at 9:21 AM, 'V. Shankar' tarakayan@yahoo.com
> [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>>
>> The same spreadsheet with smfGetYahooPortfolioView function was working
>> fine earlier in the day...now only for the first 2 rows, it returned all
>> values...I have around 135 US stock symbols in this spreadsheet. anything
>> I am missing?
>>
>
On Sat, Nov 4, 2017 at 2:38 AM, 'V. Shankar' tarakayan@
...
wrote:
>
> Version 2.1.20017.10.24; win 32 bit
>
> On 03-Nov-2017, at 10:40 PM, Randy Harmelink rharmelink@gmail.com
> [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Which version of the add-in are you using?
>
> =RCHGetElementNumber("Version")
>
> What are your first half-dozen tickers? Does it work OK just with them?
>
> On Fri, Nov 3, 2017 at 9:21 AM, 'V. Shankar' tarakayan@yahoo.com
> [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>>
>> The same spreadsheet with smfGetYahooPortfoli
>> fine earlier in the day...now only for the first 2 rows, it returned all
>> values...I have around 135 US stock symbols in this spreadsheet. anything
>> I am missing?
>>
>
Sat Nov 4, 2017 3:00 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Because RCHGetYahooQuotes() used Yahoo's current quotes CSV API, which
they've unplugged.
But smfGetYahooPortfolioView() uses the new JSON files that Yahoo uses for
their portfolio pages.
On Sat, Nov 4, 2017 at 2:42 AM, 'V. Shankar' tarakayan@yahoo.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> how come smfgeryahooporfolioview is able to get data when
> rchgetyahooquotes stopped?
>
>
>
they've unplugged.
But smfGetYahooPortfolioView() uses the new JSON files that Yahoo uses for
their portfolio pages.
On Sat, Nov 4, 2017 at 2:42 AM, 'V. Shankar' tarakayan@yahoo.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> how come smfgeryahooporfolio
> rchgetyahooquotes stopped?
>
>
>
Sat Nov 4, 2017 8:44 am (PDT) . Posted by:
oakapple2
I am using RCHGetElementNumber, element 13863, to retrieve the company name of a ticker.
It gets confused with any company that has a hyphen in its name. For example, SHW returns just "Sherwin", not "Sherwin-Williams". WMT returns just "Wal", not "Wal-Mart";. BUD returns "Anheuser";, not "Anheuser-Busch".
It appears to also get confused by periods, though this is a less common problem. EPD returns "Enterprise Products Partners L.", missing out on the last "P."
Is there any other function that converts a ticker to a name? I didn't see any.
It gets confused with any company that has a hyphen in its name. For example, SHW returns just "Sherwin"
It appears to also get confused by periods, though this is a less common problem. EPD returns "Enterprise Products Partners L.", missing out on the last "P."
Is there any other function that converts a ticker to a name? I didn't see any.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar