Kamis, 11 September 2014

[smf_addin] Digest Number 3176

15 Messages

Digest #3176
2a
(no subject) by "Kaloyan N. Kenov" isabella.ascione
2b
Re: by "Randy Harmelink" rharmelink
3a
obtaining data by "Kaloyan N. Kenov" isabella.ascione
3b
Re: obtaining data by "Randy Harmelink" rharmelink
3c
Re: obtaining data by "Kaloyan N. Kenov" isabella.ascione
3d
Re: obtaining data by isabella.ascione
3e
Re: obtaining data by "Randy Harmelink" rharmelink
3f
Re: obtaining data by isabella.ascione
3g
Re: obtaining data by "Randy Harmelink" rharmelink

Messages

Thu Sep 11, 2014 3:25 am (PDT) . Posted by:

ronaldutrecht

Hi Andy,

Is the total number of tickers to use in the formula =RCHGetYahooQuotes(B4:B203;C2:V2;;NU())
maximized till 200?


I mean is it possible to collect more then 200?


Thanks,


Ronald

Thu Sep 11, 2014 3:47 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Just 200 per formula, so:

=RCHGetYahooQuotes(B4:B203;C2:V2;;NU())
=RCHGetYahooQuotes(B204:B403;C2:V2;;NU())
=RCHGetYahooQuotes(B404:B603;C2:V2;;NU())

...and so forth.

On Thu, Sep 11, 2014 at 3:25 AM, r.kok@analist.nl [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Is the total number of tickers to use in the
> formula =RCHGetYahooQuotes(B4:B203;C2:V2;;NU())
> maximized till 200?
>
> I mean is it possible to collect more then 200?
>
>

Thu Sep 11, 2014 6:02 am (PDT) . Posted by:

ronaldutrecht

Hi Randy,

One last question: do you know how I could change the refreshing of the data, can I also change it to hourly or daily?


Thanks in advance,


Ronald

Thu Sep 11, 2014 6:14 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'm not sure exactly what you're asking.

Each time you restart EXCEL, or run the smfForceRecalculation macro, it
will refresh the formula results.

If you want to automate it, you'd need to have a VBA routine to do it.
There's an RCHGetYahooQuotes() example on the website.

On Thu, Sep 11, 2014 at 6:02 AM, r.kok@... wrote:

>
> One last question: do you know how I could change the refreshing of the
> data, can I also change it to hourly or daily?
>

Thu Sep 11, 2014 5:25 am (PDT) . Posted by:

"Kaloyan N. Kenov" isabella.ascione

Hello,

Could you help me by telling me which functions to use to obtain the
following data based on enterd ticker:

- company name

Thu Sep 11, 2014 5:31 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=RCHGetYahooQuotes("MMM","n")

On Thu, Sep 11, 2014 at 5:25 AM, 'Kaloyan N. Kenov' kenken171@... wrote:

>
> Could you help me by telling me which functions to use to obtain the
> following data based on enterd ticker:
>
> - company name
>

Thu Sep 11, 2014 5:31 am (PDT) . Posted by:

"Kaloyan N. Kenov" isabella.ascione

Hello,

I am sorry, I sent my previous email unfinished.

Could you help me by telling me which functions to use to obtain the
following data based on entered ticker:

- company name

- current stock price

- reporting or not same store sales

- earnings report date

- ex-dividend date

- aver. daily volume

The source of data is not important. How the refreshing works?

Thank you

Kaloyan

Thu Sep 11, 2014 5:37 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Name and price -- RCHGetYahooQuotes()
Same store sales -- Haven't seen a source by ticker symbol, probably
RCHGetTableCell() or smfGetTagContent() if you have a data source.
All the rest -- RCHGetElementNumber(), see the XLS in the ZIP archive for
list of data items

Average daily volume is vague, since many periods are available.

Best way to refresh is to us the smfForceRecalculation macro -- see "Tips
and FAQs" web page for more detail.

On Thu, Sep 11, 2014 at 5:30 AM, 'Kaloyan N. Kenov' kenken171@... wrote:

>
> Could you help me by telling me which functions to use to obtain the
> following data based on entered ticker:
>
> - company name
>
> - current stock price
>
> - reporting or not same store sales
>
> - earnings report date
>
> - ex-dividend date
>
> - aver. daily volume
>
> The source of data is not important. How the refreshing works?
>

Thu Sep 11, 2014 5:46 am (PDT) . Posted by:

"Kaloyan N. Kenov" isabella.ascione

Thank you

On Thu, Sep 11, 2014 at 1:37 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> Name and price -- RCHGetYahooQuotes()
> Same store sales -- Haven't seen a source by ticker symbol, probably
> RCHGetTableCell() or smfGetTagContent() if you have a data source.
> All the rest -- RCHGetElementNumber(), see the XLS in the ZIP archive for
> list of data items
>
> Average daily volume is vague, since many periods are available.
>
> Best way to refresh is to us the smfForceRecalculation macro -- see "Tips
> and FAQs" web page for more detail.
>
> On Thu, Sep 11, 2014 at 5:30 AM, 'Kaloyan N. Kenov' kenken171@... wrote:
>
>>
>> Could you help me by telling me which functions to use to obtain the
>> following data based on entered ticker:
>>
>> - company name
>>
>> - current stock price
>>
>> - reporting or not same store sales
>>
>> - earnings report date
>>
>> - ex-dividend date
>>
>> - aver. daily volume
>>
>> The source of data is not important. How the refreshing works?
>>
>
>
> ------------------------------
> Posted by: Randy Harmelink <rharmelink@gmail.com>
> ------------------------------
> Reply via web post
> <https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/26905;_ylc=X3oDMTJyYXEwb2NoBF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMyNjkwNQRzZWMDZnRyBHNsawNycGx5BHN0aW1lAzE0MTA0MzkwNTk-?act=reply&messageNum=26905>
> • Reply to sender
> <rharmelink@gmail.com?subject=Re%3A%20%5Bsmf_addin%5D%20obtaining%20data>
> • Reply to group
> <smf_addin@yahoogroups.com?subject=Re%3A%20%5Bsmf_addin%5D%20obtaining%20data>
> • Start a New Topic
> <https://groups.yahoo.com/neo/groups/smf_addin/conversations/newtopic;_ylc=X3oDMTJmNzVuODhlBF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDZnRyBHNsawNudHBjBHN0aW1lAzE0MTA0MzkwNTk->
> • Messages in this topic
> <https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/26903;_ylc=X3oDMTM3NjRkamRpBF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMyNjkwNQRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzE0MTA0MzkwNTkEdHBjSWQDMjY5MDM->
> (2)
> For the Add-in, Documentation, Templates, Tips and FAQs, visit
> http://ogres-crypt.com/SMF
> Visit Your Group
> <https://groups.yahoo.com/neo/groups/smf_addin/info;_ylc=X3oDMTJmcm83bDIxBF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDdnRsBHNsawN2Z2hwBHN0aW1lAzE0MTA0MzkwNTk->
>
> - New Members
> <https://groups.yahoo.com/neo/groups/smf_addin/members/all;_ylc=X3oDMTJnMG91MW4zBF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDdnRsBHNsawN2bWJycwRzdGltZQMxNDEwNDM5MDU5>
> 27
>
> [image: Yahoo! Groups]
> <https://groups.yahoo.com/neo;_ylc=X3oDMTJlMjBnZ2YyBF9TAzk3NDc2NTkwBGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDZnRyBHNsawNnZnAEc3RpbWUDMTQxMDQzOTA1OQ-->
> • Privacy <https://info.yahoo.com/privacy/us/yahoo/groups/details.html> •
> Unsubscribe <smf_addin-unsubscribe@yahoogroups.com?subject=Unsubscribe> • Terms
> of Use <https://info.yahoo.com/legal/us/yahoo/utos/terms/>
>
> .
>

Thu Sep 11, 2014 5:53 am (PDT) . Posted by:

isabella.ascione

Randy,

The link to
Link http://finance.groups.yahoo.com/group/smf_addin/message/7625 9.5 - FAQ: What is the smfForceRecalculation macro and how do I use it?
is returning an error

Error Description: Could not process this "GET" request.


Cannot read the description. Please advise. Thank you.





Thu Sep 11, 2014 6:07 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Thanks for letting me know. Yahoo is no longer accepting the old URL,
pre-neo. I've fixed all of the links.

Refresh that web page and try again.

On Thu, Sep 11, 2014 at 5:53 AM, kenken171@... wrote:

>
>
> The link to
> Link <http://finance.groups.yahoo.com/group/smf_addin/message/7625>9.5 -
> FAQ: What is the smfForceRecalculation macro and how do I use it?
> is returning an error
>
> Error
> ------------------------------
> *Description: Could not process this "GET" request.*
>
>
> *Cannot read the description. Please advise. Thank you.*
>
>
>

Thu Sep 11, 2014 6:12 am (PDT) . Posted by:

isabella.ascione

Thank you Randy. I tried but all the links within the Yahoo Group LINKS items (for reference purposes) group are returning the same GET error...

Thu Sep 11, 2014 6:16 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. Did you get a fresh copy of the web page? I just tried a few and
they're working fine for me. Basically, the one you had an error with was
pointing to:

http://finance.groups.yahoo.com/group/smf_addin/message/7625

...and I changed it to be:

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

But I did that for all of those links -- converting them to the "neo" URL.

On Thu, Sep 11, 2014 at 6:12 AM, kenken171@... wrote:

>
> Thank you Randy. I tried but all the links within the Yahoo Group LINKS
> items (for reference purposes) group
> are returning the same GET error...
>
>

Thu Sep 11, 2014 5:33 am (PDT) . Posted by:

holmberg_tommy

Hi Randy,


Would you be able to help me. I'm trying to create a formula that counts the debt/equity ratio from ft's balance sheet subview. So far I have only managed to create such a formula that counts debt/equity for annual data but haven't been able to do same thing for interim data.


How I should change following formula for getting the debt/equity ratio for most recent quarter:


=(RCHGetTableCell("http://markets.ft.com/research/Markets/Tearsheets/Financials?s=" & $J120 & "&subview=BalanceSheet";1;">Notes payable/short-term debt")+RCHGetTableCell("http://markets.ft.com/research/Markets/Tearsheets/Financials?s=" & $J120 & "&subview=BalanceSheet";1;">Total long term debt"))/(1000*RCHGetTableCell("http://markets.ft.com/research/Markets/Tearsheets/Financials?s=" & $J120 & "&subview=BalanceSheet";1;"Total equity"))



One example can be found at: AmTrust Financial Services Inc, AFSI:NSQ financials - FT.com http://markets.ft.com/research/Markets/Tearsheets/Financials?s=AFSI:NSQ&subview=BalanceSheet


AmTrust Financial Services Inc, AFSI:NSQ financials - FT.com http://markets.ft.com/research/Markets/Tearsheets/Financials?s=AFSI:NSQ&subview=BalanceSheet AmTrust Financial Services Inc (AFSI:NSQ) financials, including income statements, growth rates, balance sheets and cash flow information.



View on markets.ft.com http://markets.ft.com/research/Markets/Tearsheets/Financials?s=AFSI:NSQ&subview=BalanceSheet
Preview by Yahoo




Best regards: Tommy Holmberg

Thu Sep 11, 2014 5:44 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but I don't see a bookmarkable URL for the interim data. It's
dynamically placed on the page, so not available to the extraction
techniques of the add-in.

On Thu, Sep 11, 2014 at 5:33 AM, holmberg_tommy@...wrote:

>
> Would you be able to help me. I'm trying to create a formula that counts
> the debt/equity ratio from ft's balance sheet subview. So far I have
> only managed to create such a formula that counts debt/equity for annual
> data but haven't been able to do same thing for interim data.
>
> How I should change following formula for getting the debt/equity ratio
> for most recent quarter:
>
> =(RCHGetTableCell("
> http://markets.ft.com/research/Markets/Tearsheets/Financials?s=" & $J120
> & "&subview=BalanceSheet";1;">Notes payable/short-term
> debt")+RCHGetTableCell("
> http://markets.ft.com/research/Markets/Tearsheets/Financials?s=" & $J120
> & "&subview=BalanceSheet";1;">Total long term
> debt"))/(1000*RCHGetTableCell("
> http://markets.ft.com/research/Markets/Tearsheets/Financials?s=" & $J120
> & "&subview=BalanceSheet";1;"Total equity"))
>
> One example can be found at: AmTrust Financial Services Inc, AFSI:NSQ
> financials - FT.com
> <http://markets.ft.com/research/Markets/Tearsheets/Financials?s=AFSI:NSQ&subview=BalanceSheet>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 06.16

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)