Senin, 27 November 2017

[smf_addin] Digest Number 4249

10 Messages

Digest #4249

Messages

Mon Nov 27, 2017 12:05 am (PST) . Posted by:

"Randy Harmelink" rharmelink

You can ask for unadjusted close with a "u" string in the data items
parameter, but if you want unadjusted open/high/low, you'd need to compute
them yourself. I would suggest using smfGetYahooHistory() instead. At some
point, RCHGetYahooHistory() may go away.

On Sun, Nov 26, 2017 at 7:20 PM, ericstats@
​...
wrote:

> I've been using the array to toggle between pricing with and without
> adjusted pricing for dividends and gains. I use the following: *=RCHGetYahooHistory(
> Ticker, [Start Year], [Start Month], [Start Day], [End Year], [End Month],
> [End Day], [Period], [Data Items], [Header Line], [Adjust], [Resort] )* "0"
> has been used for indicating non-adjusted pricing, but I get the error
> message: Error: All data is now adjusted. Is there a way to get non
> adjusted data?
>
>
>

Mon Nov 27, 2017 1:58 am (PST) . Posted by:

shane.kelly2222

Hi Randy,


I am trying to retrieve the close price on the website table below as it seems the be a reasonably accurate source for back checking some old portfolios I have. However I have not been able to get the price using RCHGetTableCell, or SMFTagname functions. If you have time, I would appreciate any pointers you have that might see if it is possible to retrieve from that webpage, please?


https://www.historicalstockprice.com/history/?a=historical&ticker=SD&month=10&day=24&year=2014&x=9&y=9 https://www.historicalstockprice.com/history/?a=historical&ticker=SD&month=10&day=24&year=2014&x=9&y=9



=RCHGetTableCell(https://www.historicalstockprice.com/history/?a=historical&ticker=SD&month=10&day=24&year=2014&x=9&y=9,1,"Close")



I also tried breaking down the page with the SMFExamin template but could not track down the price data.


thanks for your work and any help in advance
Shane






Mon Nov 27, 2017 2:09 am (PST) . Posted by:

"Randy Harmelink" rharmelink

The data isn't in the source code of the web page. The table displayed on
the web page is dynamically created using scripting. You can extract the
table from the script code, but I'm not sure how consistent extraction will
be for different requests:

=RCHGetHTMLTable("
https://www.tickertech.net/etfchannel/cgi/?head=1&js=on&tablewidth=600&a=historical&ticker=SD&month=10&day=24&year=2014&x=9&y=9&action=https://www.historicalstockprice.com/history/
",">Date")

On Mon, Nov 27, 2017 at 2:58 AM, skelly22@
​...
wrote:

> I am trying to retrieve the close price on the website table below as it
> seems the be a reasonably accurate source for back checking some old
> portfolios I have. However I have not been able to get the price using
> RCHGetTableCell, or SMFTagname functions. If you have time, I would
> appreciate any pointers you have that might see if it is possible to
> retrieve from that webpage, please?
>
> https://www.historicalstockprice.com/history/?a=historical&ticker=
> SD&month=10&day=24&year=2014&x=9&y=9
>
> =RCHGetTableCell(https://www.historicalstockprice.com/
> history/?a=historical&ticker=SD&month=10&day=24&year=2014&x=9&y=9,1,
> "Close")
>
> I also tried breaking down the page with the SMFExamin template but could
> not track down the price data.
>
> thanks for your work and any help in advance
>
>
>

Mon Nov 27, 2017 3:38 am (PST) . Posted by:

shane.kelly2222

Many Thanks Randy!! that gets the full table in when array entered.

Date https://www.tickertech.net/etfchannel/cgi/?head=1&js=on&tablewidth=600&a=historical&ticker=SD&month=10&day=24&year=2014&x=9&y=9&action=https://www.historicalstockprice.com/history/ Open High Low Close 10/24/2014 4.04 4.08 3.8 3.95

Thanks Again, Shane


















Mon Nov 27, 2017 11:56 am (PST) . Posted by:

richmond0039

On the PC where everything works fine, =RCHGetElementNumber("Version") returns
Stock Market Functions add-in, Version 2.1.2017.11.11 (C:\Program Files\SMF Add-In; Windows (32-bit) NT 10.00; 16.0; ; ; 1)


On the PC where I do not see the SMF option in the context menu when I right click a cell, it returns
Stock Market Functions add-in, Version 2.1.2017.11.11 (C:\Program Files\SMF Add-In; Windows (32-bit) NT 10.00; 16.0; ; ; 1)




Mon Nov 27, 2017 12:07 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Not a clue as to why one would have it and the other not. No messages come
up?

You could try running the "Auto_Open" routine manually (as a macro) and see
if you get any messages.

On Mon, Nov 27, 2017 at 12:56 PM, dcash@
​...
wrote:

>
> On the PC where everything works fine, =RCHGetElementNumber("Version")
> returns
> Stock Market Functions add-in, Version 2.1.2017.11.11 (C:\Program
> Files\SMF Add-In; Windows (32-bit) NT 10.00; 16.0; ; ; 1)
>
> On the PC where I do not see the SMF option in the context menu when I
> right click a cell, it returns
> Stock Market Functions add-in, Version 2.1.2017.11.11 (C:\Program
> Files\SMF Add-In; Windows (32-bit) NT 10.00; 16.0; ; ; 1)
>
>

Mon Nov 27, 2017 2:41 pm (PST) . Posted by:

sabasu

Hi Randy,


I have been able to implement the smfGetYahooPortfolioView function quite successfully. I say 'quite" because when I have a repeating SOURCE cell-value in an array, the second cell-value is not returning the corresponding DESTINATION value. For example, if I have 2 HCN symbols in B5 and B6 as part of the array, the function returns the correct value for B5 but does not return any value for B6. Am I doing something wrong?


Thanks for your superb work,


Basu

Mon Nov 27, 2017 2:51 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Currently, smfGetYahooPortfolioView() only returns data for the first
occurrence of a ticker symbol, because it required additional overhead
processing to check and see if it needed to be returned more than once.

The next release of the add-in will have the ability to return the data for
each time a ticker symbols is passed in the smfGetYahooPortfolioView() and
smfGetBarchartPortfolioView(). However, it will require an override to do
so (setting the third parameter to "Y", which otherwise defaults to "N").

My usage of those functions is to get the data in one worksheet, then do
lookups into that sheet from other worksheets. That way, it's easier to
replace if Yahoo unplugs the data again. It was also a way to handle the
data being returned once, or returned out-of-order. From that perspective,
it didn't matter if I looked it up multiple times.

On Mon, Nov 27, 2017 at 3:41 PM, sabasu@
​...
wrote:

> I have been able to implement the smfGetYahooPortfolioView function quite
> successfully. I say 'quite" because when I have a repeating SOURCE
> cell-value in an array, the second cell-value is not returning the
> corresponding DESTINATION value. For example, if I have 2 HCN symbols in B5
> and B6 as part of the array, the function returns the correct value for B5
> but does not return any value for B6. Am I doing something wrong?
>
>
>

Mon Nov 27, 2017 4:12 pm (PST) . Posted by:

sabasu

Hi Randy and folks,




The RCHGetElementNumber function for element numbers 886,887 and 888 are returning 'Error' values. These are Morningstar Fair value estimate, Consider Buying, Consider Selling respectively. My version number is as below. I am also a premium member of Morninstar and ensured that I am logged-in to my premium account by using alt+d+d+w, though I am not sure how to set up Security Cookie in IE11 in Windows 7.


Even the smfTagContent function returns me an 'Error'


Stock Market Functions add-in, Version 2.1.2017.11.11 (C:\SMF_ADDIN; Windows (32-bit) NT 6.01; 15.0; ; Local; 1)

Mon Nov 27, 2017 5:16 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The three elements are working here, so I'll assume it's a lack of a
security cookie.

With Win10, I found I was required to use the alt+d+d+w IE object to create
the security cookie. Did you try the elements first, then log in? If so,
you do need to run the smfForceRecalculation macro to force the add-in to
retrieve new copies of the web pages, post-login.

On Mon, Nov 27, 2017 at 5:12 PM, sabasu@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> The RCHGetElementNumber function for element numbers 886,887 and 888 are
> returning 'Error&#39; values. These are Morningstar Fair value estimate,
> Consider Buying, Consider Selling respectively. My version number is as
> below. I am also a premium member of Morninstar and ensured that I am
> logged-in to my premium account by using alt+d+d+w, though I am not sure
> how to set up Security Cookie in IE11 in Windows 7.
>
> Even the smfTagContent function returns me an 'Error&#39;
>
> Stock Market Functions add-in, Version 2.1.2017.11.11 (C:\SMF_ADDIN;
> Windows (32-bit) NT 6.01; 15.0; ; Local; 1)
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 18.08

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)