Jumat, 07 Maret 2014

[smf_addin] Digest Number 2995[1 Attachment]

15 Messages

Digest #2995
1a
Re: Hey by "Randy Harmelink" rharmelink
2b
Re: FW: Updates in Your Groups, March 7, 2014 by "Randy Harmelink" rharmelink
3a
Figuring Basis by almondtree
3b
Re: Figuring Basis by "Kermit W. Prather" kermitpra
3c
Re: Figuring Basis by "Randy Harmelink" rharmelink
3d
Re: Figuring Basis by almondtree
4a
Solid State Drive by almondtree
4b
Re: Solid State Drive by "Kermit W. Prather" kermitpra
4c
4d
Re: Solid State Drive by "Peter Urbani" purbani1

Messages

Fri Mar 7, 2014 1:11 am (PST) . Posted by:

"Randy Harmelink" rharmelink

The LINKS area of the Yahoo group has now been moved to the SMF website:

http://ogres-crypt.com/SMF/Tips-and-FAQs/

The two tips you should take a look at are:

Link <http://finance.groups.yahoo.com/group/smf_addin/message/10464>AdvFN.001
- A possible fix for "Error" responses from AdvFN due to a change from a
Windows Update.
Link<http://finance.groups.yahoo.com/group/smf_addin/message/21069>AdvFN.002
- A workaround for AdvFN users that get redirected to one of their regional
domains
...except that you would use "in" instead of "uk" for the advice in the
second link.

Remember that you need to exit EXCEL before making those changes. When you
restart EXCEL, it should load all the new settings. And hopefully work.

Actually, the URL I should have given you for testing redirection is:

http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM

If you need the "in" prefix, that should redirect you to:

http://in.advfn.com/exchanges/NYSE/MMM/financials?mode=quarterly_reports

If you don't need the "in" prefix, it shoulld redirect you to:

http://www.advfn.com/exchanges/NYSE/MMM/financials?mode=quarterly_reports

On Fri, Mar 7, 2014 at 12:56 AM, <vijay_gangrade@yahoo.com> wrote:

>
> =RCHGetElementNumber("Version") returns "Stock Market Functions add-in,
> Version 2.1.2014.01.30 (C:\SMF Add-In; www; 1)" which seems most recent
> version.
>
> I am from India but the URL
> http://www.advfn.com/exchanges/NYSE/MMM/stock-price doesn't redirect me
> anywhere. I tried in both Firefox and IE. However http://<http://www.advfn.com/exchanges/NYSE/MMM/stock-price>
> www.advfn.com <http://www.advfn.com.> does redirect me to
> http://in.advfn.com/
> I don't think it should matter since then I tried
> http://in.advfn.com/exchanges/NYSE/MMM/stock-price<http://www.advfn.com/exchanges/NYSE/MMM/stock-price>but that resulted in 404 error.
>
> I am in the process of checking Links area as you suggested. Is there
> anything else I should try in addition to that.
>

On Fri, Mar 7, 2014 at 1:03 AM, vijay gangrade <vijay_gangrade@yahoo.com>wrote:

>
> I forgot to mention in previous mail. I have tried this in Windows Vista
> as well as Windows XP but am getting the same result.
>
>

Fri Mar 7, 2014 8:09 am (PST) . Posted by:

"Pete A" option2z

Randy,
Finally found one feature of the YAHOO File system that is useful to me. Below is an example. Essentially, it notifies me whenever ANYONE posts a file to the group, keeping me up on what's happening without constantly having to look at the folders for last updated dates.

Will you be making an update to the YAHOO Group Files when you post to ogrecrypt?

Pete A


Updates in Your Groups
<http://groups.yahoo.com/group/smf_addin/?prop=eupdate> smf_addin-EXCEL Stock Market Functions Add-in

<http://l.yimg.com/a/i/us/yg/em/up/2/icon_file_v2.gif>
<http://profiles.yahoo.com/rharmelink> rharmelink posted a file "0-READ-ME.html" to the <http://groups.yahoo.com/group/smf_addin/files/Documentation?prop=eupdate> Documentation folder

<http://l.yimg.com/a/i/us/yg/em/up/2/icon_file_v2.gif>
<http://profiles.yahoo.com/rharmelink> rharmelink posted a file "0-READ-ME.html" to the <http://groups.yahoo.com/group/smf_addin/files/Add-In%20Files?prop=eupdate> Add-In Files folder

<http://l.yimg.com/a/i/us/yg/em/up/2/icon_file_v2.gif>
<http://profiles.yahoo.com/rharmelink> rharmelink posted a file "0-READ-ME.html" to the <http://groups.yahoo.com/group/smf_addin/files/Works-In-Progress?prop=eupdate> Works-In-Progress folder
<http://groups.yahoo.com/mygroups> Visit Your Groups <http://groups.yahoo.com/unsubscribe/updates/_uGhKYgCQi7njkdCpqKnG7Gw092J56lM> • Unsubscribe from the Updates Email
<http://l.yimg.com/ru/static/images/yg/img/email/new_logo/logo-groups-137x15.png>
• Privacy. • <http://info.yahoo.com/legal/us/yahoo/utos/terms/> Terms of Use
<http://geo.yahoo.com/b?s=1158100159&t=561441538>

Fri Mar 7, 2014 11:21 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I've never received anything like that for any of the Yahoo groups I'm in.
How did you get it?

I'll have to think about how to do something like that, once things are
stabilized.

On Fri, Mar 7, 2014 at 9:09 AM, Pete A <optionzz@gmail.com> wrote:

> Randy,
>
> Finally found one feature of the YAHOO File system that is useful to me. Below
> is an example. Essentially, it notifies me whenever ANYONE posts a file
> to the group, keeping me up on what's happening without constantly having
> to look at the folders for last updated dates.
>
>
>
> Will you be making an update to the YAHOO Group Files when you post to
> ogrecrypt?
>
>
>
> Pete A
>
>
>
> *Updates in Your Groups*
>
> smf_addin-EXCEL Stock Market Functions Add-in<http://groups.yahoo.com/group/smf_addin/?prop=eupdate>
>
> *rharmelink* <http://profiles.yahoo.com/rharmelink> posted a file
> "0-READ-ME.html" to the *Documentation*<http://groups.yahoo.com/group/smf_addin/files/Documentation?prop=eupdate>folder
>
> *rharmelink* <http://profiles.yahoo.com/rharmelink> posted a file
> "0-READ-ME.html" to the *Add-In Files*<http://groups.yahoo.com/group/smf_addin/files/Add-In%20Files?prop=eupdate>folder
>
> *rharmelink* <http://profiles.yahoo.com/rharmelink> posted a file
> "0-READ-ME.html" to the *Works-In-Progress*<http://groups.yahoo.com/group/smf_addin/files/Works-In-Progress?prop=eupdate>folder
>
>

Fri Mar 7, 2014 11:58 am (PST) . Posted by:

"Jacob Jose" pepecan47

I receive an email as well from Yahoo groups everytime there is an update.

Regards,
Jose L. Jacob

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Friday, March 7, 2014 2:21:34 PM
Subject: Re: [smf_addin] FW: Updates in Your Groups, March 7, 2014

 
I've never received anything like that for any of the Yahoo groups I'm in. How did you get it?

I'll have to think about how to do something like that, once things are stabilized.

On Fri, Mar 7, 2014 at 9:09 AM, Pete A <optionzz@gmail.com> wrote:

Randy,
>Finally found one feature of the YAHOO File system that is useful to me.  Below is an example.  Essentially, it notifies me whenever ANYONE posts a file to the group, keeping me up on what's happening without constantly having to look at the folders for last updated dates.
> 
>Will you be making an update to the YAHOO Group Files when you post to ogrecrypt?
> 
>Pete A
> 
>Updates in Your Groups
>smf_addin-EXCEL Stock Market Functions Add-in
> rharmelink posted a file "0-READ-ME.html" to the Documentation folder
> rharmelink posted a file "0-READ-ME.html" to the Add-In Files folder
> rharmelink posted a file "0-READ-ME.html" to the Works-In-Progress folder
>

Fri Mar 7, 2014 10:09 am (PST) . Posted by:

almondtree

if I bought 200 shares at 7.45 and its now 16.45 a share how many shares would I need to sell for basis.
I like would a formula box to move around spreadsheet. Thanks, what happened old search box on this site.


Fri Mar 7, 2014 11:06 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

Surely, you can calculate that

PS = purchased shares
PP = Purchase price
S = Sell price

PS * PP/ SP

(200 * 7.45) / 16.45 = 91

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of almondtree@yahoo.com
Sent: Friday, March 07, 2014 1:09 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Figuring Basis


if I bought 200 shares at 7.45 and its now 16.45 a share how many shares would I need to sell for basis.
I like would a formula box to move around spreadsheet. Thanks, what happened old search box on this site.


Fri Mar 7, 2014 11:24 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Like Kermit said, that should be simple enough to compute yourself. That's
what EXCEL is for.

For searching the message archive, just use the search box at the top. You
should see that it says, "Search Conversations"...

On Fri, Mar 7, 2014 at 11:09 AM, <almondtree@yahoo.com> wrote:

> if I bought 200 shares at 7.45 and its now 16.45 a share how many shares
> would I need to sell for basis.
>
> I like would a formula box to move around spreadsheet. Thanks, what
> happened old search box on this site.
>

Fri Mar 7, 2014 11:52 am (PST) . Posted by:

almondtree

Thanks, well brain dead ME, I was just over on google and they just like to word you death on simple questions so I figured its easier here then google.

Fri Mar 7, 2014 10:12 am (PST) . Posted by:

almondtree

My Hard drive is dying does any have an opinion on a good SSD? I have been looking 500GB SSD.

Fri Mar 7, 2014 11:11 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

Really, how do you know it is dying?

Personally, I recommend you have a smaller system hard drive. Only install the windows on it and put everything else on an external hard drive.

But that's just my opinion.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of almondtree@yahoo.com
Sent: Friday, March 07, 2014 1:12 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Solid State Drive


My Hard drive is dying does any have an opinion on a good SSD? I have been looking 500GB SSD.

Fri Mar 7, 2014 11:52 am (PST) . Posted by:

almondtree

Windows 7 S.m.a.r.t says it is and F2 on restart. I have a 1tb and I use only 21% of drive so an Samsung SSD 500gb drive is 279 at Amazon. But, want to know if others are using ssd's in their systems.

Fri Mar 7, 2014 11:57 am (PST) . Posted by:

"Peter Urbani" purbani1

SSD's are great but whatever you don't upgrade to Windows 8.1 as it does
not play nicely with SSD's and freezes every now and then. Access speeds
also significantly slower than for Windows 7 & 8.

On Sat, Mar 8, 2014 at 8:52 AM, <almondtree@yahoo.com> wrote:

>
>
> Windows 7 S.m.a.r.t says it is and F2 on restart. I have a 1tb and I use
> only 21% of drive so an Samsung SSD 500gb drive is 279 at Amazon. But, want
> to know if others are using ssd's in their systems.
>
>

--

*Peter Urbani*

+64 6 378 0937

LinkedIn Profile <http://nz.linkedin.com/in/peterurbani>

Skype peterurbani

Fri Mar 7, 2014 11:22 am (PST) . Posted by:

luiscadler

Hi! I am also having problems in Excel 2010. When I run the RCHGetYahooHistory formula, it retrieves all the Column Titles (Ticker, Date, Open, etc), iT returns the Ticker, the date, but no other items! ie. I don't get the Open price, the close price, nothing. When I try to run this in any other computer, it works. Below is the formula I'm using, and I've attached the example sheet:


=+RCHGetYahooHistory("AAPL&quot;;2014;1;1;2014;3;6;"m";"TDOHLCVA&quot;)



Other RCH formulas work, such as the RCHGetYahooQuotes.


I have been using this for years and I am really confused by what may be happening and how to solve it.


Thank you in advance!
Luis




Attachment(s) from
1 of 1 File(s)

Fri Mar 7, 2014 11:31 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Your workbook works fine here. I suspect it has something to do with the
regional settings on your computer. The RCHGetYahooHistory() function
attempt to convert a date from a string value into an EXCEL serial date. If
the regional settings are set to expect a different format of a date in
string value, it will probably abort the function.

On Fri, Mar 7, 2014 at 9:16 AM, <luiscadler@yahoo.co.uk> wrote:

>
> I am also having problems in Excel 2010. When I run the RCHGetYahooHistory
> formula, it retrieves all the Column Titles (Ticker, Date, Open, etc), iT
> returns the Ticker, the date, but no other items! ie. I don't get the Open
> price, the close price, nothing. When I try to run this in any other
> computer, it works. Below is the formula I'm using, and I've attached the
> example sheet:
>
> =+RCHGetYahooHistory("AAPL&quot;;2014;1;1;2014;3;6;"m";"TDOHLCVA&quot;)
>
> Other RCH formulas work, such as the RCHGetYahooQuotes.
>
> I have been using this for years and I am really confused by what may be
> happening and how to solve it.
>
>

Fri Mar 7, 2014 12:02 pm (PST) . Posted by:

"Jacob Jose" pepecan47


Randy, see below the notification I get.

Regards,
Jose L. Jacob

----- Forwarded Message -----
From: Yahoo Groups Updates <groupsupdates@yahoogroups.com>
To: pepecan47@yahoo.ca
Sent: Tuesday, March 4, 2014 9:20:57 AM
Subject: Updates in Your Groups, March 4, 2014

Updates in Your Groups

smf_addin
rharmelink posted a file "0-READ-ME.html" to the Templates and Examples/RCHGetYahooQuotes folder
Visit Your Groups • Unsubscribe from the Updates Email
• Privacy. • Terms of Use
Diposting oleh EXCEL FEED LEARNING di 12.02

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)