Sabtu, 03 Januari 2015

[smf_addin] Digest Number 3284

6 Messages

Digest #3284

Messages

Fri Jan 2, 2015 1:10 pm (PST) . Posted by:

zzolaman

Has there been any response to this query? I too would like to know how to find non-adjusted closing prices...

Fri Jan 2, 2015 1:13 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The RCHGetYahooHistory() function can return either or both adjusted and
non-adjusted closing prices, as long as Yahoo carries them in CSV file
format.

On Fri, Jan 2, 2015 at 1:35 PM, trevor.mchaney@... wrote:

> Has there been any response to this query? I too would like to know how
> to find non-adjusted closing prices...
>

Fri Jan 2, 2015 2:44 pm (PST) . Posted by:

analyst101010

Hi everybody

I think this has been gone over many times before...


...but a while back the default location for the SMF files was in C:/Program Files/SMF Add-In/

....and now most Templates reference "C:/SMF Add-In/

I've been cleaning up a lot of older junk and files which had cut/pasted references from older templates, and I find that now whenever I open Excel (Office 2007) it tells me it can't find the original SMF files in the old location.

IOW, i have to remove and reload the add-in reference location whenever I open Excel. Its annoying. Isn't there some setting deeper in Excel where i can tell it to stop looking in the old location? It seems to want to go back there whenever i use older templates.

Any help? Link to previous answer, thank in advance...

Happy New Year, Randy et al


Fri Jan 2, 2015 3:13 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Sorry about that -- I had to move my usage of the add-in to "C:/SMF
Add-In/" because the Vista operating system wouldn't let me save changes to
the XLA file when it was located in the "Program Files" folder.

However, you don't need to reload the add-in. If you have location errors,
just run the smfFixLinks macro. I use it quite a bit myself, so I have it
on a button on my Quick Access Toolbar (along the smfForceRecalculation and
smfUpdateDownloadTable).

The smfFixLinks macro basically just does a "find and replace all" on all
of the location prefixes in front of the add-in functions, removing them.
This leaves the add-in function, which EXCEL then finds via the add-in
manager setup.

EXCEL won't do it automatically, because it hard-codes the location of the
add-in function whenever a file is saved. When the file is later opened, if
it doesn't find the resource in that location, it tags it as an "unresolved
link". EXCEL doesn't know that it's an add-in reference unless the link is
resolved. So, kind of a "Catch 22" situation.

On Fri, Jan 2, 2015 at 3:44 PM, jfgilmore@... wrote:

>
> I think this has been gone over many times before...
>
> ...but a while back the default location for the SMF files was in
> C:/Program Files/SMF Add-In/
>
> ....and now most Templates reference "C:/SMF Add-In/
>
> I've been cleaning up a lot of older junk and files which had cut/pasted
> references from older templates, and I find that now whenever I open Excel
> (Office 2007) it tells me it can't find the original SMF files in the old
> location.
>
> IOW, i have to remove and reload the add-in reference location whenever I
> open Excel. Its annoying. Isn't there some setting deeper in Excel where i
> can tell it to stop looking in the old location? It seems to want to go
> back there whenever i use older templates.
>
> Any help? Link to previous answer, thank in advance...
>

Fri Jan 2, 2015 9:19 pm (PST) . Posted by:

blm3@sbcglobal.net

RCHGetElementNumber generates and uses the link


'http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=T"


but that link takes me to the home page ("http://www.msn.com/en-us/money"). This link sends me to the stock page


"http://www.msn.com/en-us/money/stockdetails/fi-126.1.T.NYS?symbol=T&form=PRFISB"


but the layout looks like it is very different(?). And if I use an ETF instead, it takes me to


"http://www.msn.com/en-us/money/etfdetails/fi-126.1.IDU.ARCX?symbol=IDU&form=PRFISB"


It looks like MSN has changed its layout and SMF has not yet caught up? and element 13862 may not still be SEF since the link has to go to one of the two pages URLs?


Thank you for your time.

Fri Jan 2, 2015 9:40 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Yes, you did miss something -- back at the end of September:

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

Bottom line -- all MSN data is currently obsolete. The web pages I get
using the add-in have even less data on them then what I can see in FireFox
or Chrome.

On Fri, Jan 2, 2015 at 10:19 PM, blm3@... wrote:

> RCHGetElementNumber generates and uses the link
>
> '
> http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=T"
>
>
> but that link takes me to the home page ("http://www.msn.com/en-us/money").
> This link sends me to the stock page
>
> "
> http://www.msn.com/en-us/money/stockdetails/fi-126.1.T.NYS?symbol=T&form=PRFISB
> "
>
> but the layout looks like it is very different(?). And if I use an ETF
> instead, it takes me to
>
> "
> http://www.msn.com/en-us/money/etfdetails/fi-126.1.IDU.ARCX?symbol=IDU&form=PRFISB
> "
>
> It looks like MSN has changed its layout and SMF has not yet caught up?
> and element 13862 may not still be SEF since the link has to go to one of
> the two pages URLs?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar