Jumat, 27 Juli 2018

[smf_addin] Digest Number 4368

10 Messages

Digest #4368
1b
2a
Re: zacks: key-company-metrics by "Randy Harmelink" rharmelink
2b
3a
SMF excel add in on Mac by thingthing_kee
3b
Re: SMF excel add in on Mac by "Randy Harmelink" rharmelink
3c
Re: SMF excel add in on Mac by sam.leesunwah@yahoo.com
3d
Re: SMF excel add in on Mac by "Randy Harmelink" rharmelink
3e
Re: SMF excel add in on Mac by sam.leesunwah@yahoo.com
3f
Re: SMF excel add in on Mac by "Randy Harmelink" rharmelink

Messages

Thu Jul 26, 2018 7:00 am (PDT) . Posted by:

"Peter Cook" pete_cook2001

Randy, are the values in your field # column stored as text?

On Thu, Jul 26, 2018 at 3:33 AM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> Not sure what to tell you -- I used this formula:
>
> =TRANSPOSE(smfGetYahooPortfolioView("TSLA";,B3:B94,,,1,100))
>
> ...and TSLA works fine for me:
>
> *Field #* *Field Description* *Yahoo field name* *Values*
> 00 N/A N/A --
> 01 Symbol symbol TSLA
> 02 Long Name longName Tesla, Inc.
> 03 Short Name shortName Tesla, Inc.
> 04 Exchange exchange NMS
> 05 Full Exchange Name fullExchangeName NasdaqGS
> 06 Market market us_market
> 07 Market State marketState PREPRE
> 08 Source Interval sourceInterval 15
> 09 Exchange Timezone Name exchangeTimezoneName America/New_York
> 10 Exchange Timezone Short Name exchangeTimezoneShortName EDT
> 11 GMT Offset Milliseconds gmtOffSetMilliseconds -14400000
> 12 Language language en-US
> 13 Quote Type quoteType EQUITY
> 14 Quote Source Name quoteSourceName Nasdaq Real Time Price
> 15 Last Price regularMarketPrice 308.74
> 16 Last Traded (UNIX) regularMarketTime 1532548801
> 17 Change regularMarketChange 11.309998
> 18 Open regularMarketOpen 296.74
> 19 High regularMarketDayHigh 309.62
> 20 Low regularMarketDayLow 294.5025
> 21 Volume regularMarketVolume 6913824
>
> On Wed, Jul 25, 2018 at 9:36 AM, peterscottcook@
> ​...
> wrote:
>
>>
>> I'm not sure if this is the same issue, but there are many stocks for
>> which smfgetyahooportfolioview() pulls data and there are many for which it
>> doesn't.
>>
>> I simply took the "field numbers" tab of the
>> smfgetyahooportfolioview-sample.xls sheet and added a ticker field plus
>> a column which returns the function's value using the ticker and the field
>> number for that row.
>>
>> If I plug in "F" for the ticker, all of the cells in that column return
>> the correct data. If I change the ticker to "TSLA" all of the cells return
>> "--".
>>
>>
>>
>
>
>

Thu Jul 26, 2018 10:07 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

They are. But when using a range as input for the field numbers, it doesn't
matter. The only time the 2-byte strings matter is when you pass a string
literal as the parameter.

On Thu, Jul 26, 2018 at 7:00 AM, Peter Cook peterscottcook@
....
wrote:

>
> Randy, are the values in your field # column stored as text?
>
> On Thu, Jul 26, 2018 at 3:33 AM, Randy Harmelink
> ...
> wrote:
>
>>
>> Not sure what to tell you -- I used this formula:
>>
>> =TRANSPOSE(smfGetYahooPortfolioView("TSLA";,B3:B94,,,1,100))
>>
>> ...and TSLA works fine for me:
>>
>> *Field #* *Field Description* *Yahoo field name* *Values*
>> 00 N/A N/A --
>> 01 Symbol symbol TSLA
>> 02 Long Name longName Tesla, Inc.
>> 03 Short Name shortName Tesla, Inc.
>> 04 Exchange exchange NMS
>> 05 Full Exchange Name fullExchangeName NasdaqGS
>> 06 Market market us_market
>> 07 Market State marketState PREPRE
>> 08 Source Interval sourceInterval 15
>> 09 Exchange Timezone Name exchangeTimezoneName America/New_York
>> 10 Exchange Timezone Short Name exchangeTimezoneShortName EDT
>> 11 GMT Offset Milliseconds gmtOffSetMilliseconds -14400000
>> 12 Language language en-US
>> 13 Quote Type quoteType EQUITY
>> 14 Quote Source Name quoteSourceName Nasdaq Real Time Price
>> 15 Last Price regularMarketPrice 308.74
>> 16 Last Traded (UNIX) regularMarketTime 1532548801
>> 17 Change regularMarketChange 11.309998
>> 18 Open regularMarketOpen 296.74
>> 19 High regularMarketDayHigh 309.62
>> 20 Low regularMarketDayLow 294.5025
>> 21 Volume regularMarketVolume 6913824
>>
>> On Wed, Jul 25, 2018 at 9:36 AM, peterscottcook@
>> ...
>> wrote:
>>
>>>
>>> I'm not sure if this is the same issue, but there are many stocks for
>>> which smfgetyahooportfolioview() pulls data and there are many for which it
>>> doesn't.
>>>
>>> I simply took the "field numbers" tab of the
>>> smfgetyahooportfolioview-sample.xls sheet and added a ticker field plus
>>> a column which returns the function's value using the ticker and the field
>>> number for that row.
>>>
>>> If I plug in "F" for the ticker, all of the cells in that column return
>>> the correct data. If I change the ticker to "TSLA" all of the cells return
>>> "--".
>>>
>>>
>>>

Thu Jul 26, 2018 10:01 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try something like:

=smfGetTagContent("
https://www.zacks.com/stock/research/FB/key-company-metrics
","li",2,"id=""annual_metrics""",">Revenue-Advertising",,,1)
=smfGetTagContent("
https://www.zacks.com/stock/research/FB/key-company-metrics","li",2,"id=""annual_metrics""",">Revenue-Advertising","Hist
Estimate",,1)
=smfGetTagContent("
https://www.zacks.com/stock/research/FB/key-company-metrics
","li",2,"id=""annual_metrics""",">Revenue-Advertising",">Surprise",,1)

=smfGetTagContent("
https://www.zacks.com/stock/research/FB/key-company-metrics
","li",2,"id=""quarterly_metrics""",">Revenue-Advertising",,,1)
=smfGetTagContent("
https://www.zacks.com/stock/research/FB/key-company-metrics","li",2,"id=""quarterly_metrics""",">Revenue-Advertising","Hist
Estimate",,1)
=smfGetTagContent("
https://www.zacks.com/stock/research/FB/key-company-metrics
","li",2,"id=""quarterly_metrics""",">Revenue-Advertising",">Surprise",,1)

On Thu, Jul 26, 2018 at 4:10 AM, stan_12@
....
wrote:

>
> has anyone an idea how to get this site into Excel?
>
> https://www.zacks.com/stock/research/FB/key-company-metrics
>
> My aim is to change the symbol in Excel and then pull the data dynamically.
>
> I tried:
>
> 1.) "csv-download&quot;
> But it is rather an xls Download with non standard tab names. So difficult
> to refer to.
>
> 2.) SMF Quick Webpage Examination by html Tag
> But i could find a suitable tag.
>
>
>

Fri Jul 27, 2018 12:58 am (PDT) . Posted by:

thingthing_kee

I know it was mentioned that this add-in could not be used on Mac without s simulated windows environment. Just want to check if we can use it on Mac now. Thanks!




Fri Jul 27, 2018 1:04 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

About two years ago, a MAC user gave me some MAC-specific code to replace
my Windows processing. It worked for him. But results from other MAC users
were spotty. For some it worked. Others not. The instructions he wrote up
at the time:

http://ogres-crypt.com/SMF/Works-In-Progress/MAC-Instructions.html

I'm not a MAC user, so there's nothing I can do personally to get it to
work there.

On Thu, Jul 26, 2018 at 9:15 PM, thingthing@
....
wrote:

> I know it was mentioned that this add-in could not be used on Mac without
> s simulated windows environment. Just want to check if we can use it on Mac
> now. Thanks!
>
>
>

Fri Jul 27, 2018 3:14 am (PDT) . Posted by:

sam.leesunwah@yahoo.com

Hi Randy,

I managed to use the module in MAC. I mainly retrieve data from Zacks and IBD. Until beginning of the week I experience a "I'm not a robot" check during the IBD web site login then the cookies generated is no longer work. Seems the robot check has last for a few days already. Any idea how I can make it works again?


Thanks for your help in advance.


Sam

Fri Jul 27, 2018 3:23 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Were you getting data on a lot of companies? IBD does have a limit on the
number of stock checkups you can do within a 24-hour period (300?). I've
also had people get temporarily locked out of Zacks. I think that took
about a week to clear up?

Someone else indicated they were getting the captchas on IBD as well. I
suspect that is based on the IP address, so there's probably nothing you
can do except wait it out and hope it's just temporary. You could try
deleting any cookies for the site, but I'm not even sure if that can be
done for the EXCEL IE object. It uses different settings and file locations
than the normal IE browser.

On Fri, Jul 27, 2018 at 3:12 AM, sam.leesunwah@
....
wrote:

>
> I managed to use the module in MAC. I mainly retrieve data from Zacks and
> IBD. Until beginning of the week I experience a "I'm not a robot" check
> during the IBD web site login then the cookies generated is no longer work.
> Seems the robot check has last for a few days already. Any idea how I can
> make it works again?
>
>
>

Fri Jul 27, 2018 3:45 am (PDT) . Posted by:

sam.leesunwah@yahoo.com

Hi Randy,

Usually I retrieve data for one stock at a time but may be multiple requests for different data. 300 request limit is very easy to meet. However, I have used the same process for over 1 year and nothing happened until this week.


Do you come across a way to retrieve the top 5 stocks for a IBD industry group?


Regards,


Sam.

Fri Jul 27, 2018 5:10 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You can get the top four (of any of the listed ratings) from the stock
checkup page for a stock within the industry group. Top five if that stock
is one of the five.

On Fri, Jul 27, 2018 at 3:45 AM, sam.leesunwah@
....
wrote:

>
> Do you come across a way to retrieve the top 5 stocks for a IBD industry
> group?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 05.42

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)