Messages In This Digest (3 Messages)
- 1a.
- Re: HardCoat cell that has formula once the formula returns a value From: rb_luther
- 1b.
- Re: HardCoat cell that has formula once the formula returns a value From: Randy Harmelink
- 2a.
- Re: Schwab Weekly - Followup From: smithjhhic
Messages
- 1a.
-
Re: HardCoat cell that has formula once the formula returns a value
Posted by: "rb_luther" rb_luther@yahoo.com rb_luther
Mon Mar 26, 2012 12:55 pm (PDT)
The spreadsheet attached was a bare bones look at my model. The all inclusive model is being used as a performance calculator, and statement generator, for friends, family, and my personal portfolios. Using the Chartered Financial Analyst (CFA) recommended Global Investment Performance Standards (GIPS), the portfolio should be balanced daily.
I do not want to bog down the free sites, which is why I am looking to retrieve price data for the stocks in my funds portfolio and then hardcoating the historical prices, so the next time the macro is run, prior prices will not be retrieved again. (I currently input each days price for my holdings and then manually hardcoat them).
Do you know of VBA code to achieve this? (ie. formula retrieves stock price, and then the same cell hardcoates itself by running a macro possibly, if today's date is greater than the date the stock price was retrieved.)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Your file just showed up. Oh my goodness, WHY are you retrieving
> historical data one day at a time?
>
> On Sat, Mar 24, 2012 at 1:53 PM, rb_luther <rb_luther@...> wrote:
>
> > I have a question regarding the SMFAddin. An example of my spreadsheet is
> > in the "attachments" area with the file name "Hard Coat Stock Price
> > Trial1.xlsx".
> >
>
- 1b.
-
Re: HardCoat cell that has formula once the formula returns a value
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Mar 26, 2012 2:27 pm (PDT)
Then you have to worry about adjustments to the data, for dividends,
splits, symbol changes, spinoffs, etc. I used to do that and never will
again -- it's a real pain to keep things up to date.
In any case, your "hardcoating" would probably be best done by having the
VBA put values in the cells. That is, invoking the formulas from VBA
instead of the workbook. Take a look at the example from the "Links" area
of the group.
On Mon, Mar 26, 2012 at 12:55 PM, rb_luther <rb_luther@yahoo.com > wrote:
> The spreadsheet attached was a bare bones look at my model. The all
> inclusive model is being used as a performance calculator, and statement
> generator, for friends, family, and my personal portfolios. Using the
> Chartered Financial Analyst (CFA) recommended Global Investment Performance
> Standards (GIPS), the portfolio should be balanced daily.
>
> I do not want to bog down the free sites, which is why I am looking to
> retrieve price data for the stocks in my funds portfolio and then
> hardcoating the historical prices, so the next time the macro is run, prior
> prices will not be retrieved again. (I currently input each days price for
> my holdings and then manually hardcoat them).
>
> Do you know of VBA code to achieve this? (ie. formula retrieves stock
> price, and then the same cell hardcoates itself by running a macro
> possibly, if today's date is greater than the date the stock price was
> retrieved.)
>
- 2a.
-
Re: Schwab Weekly - Followup
Posted by: "smithjhhic" smithjhhic@yahoo.com smithjhhic
Mon Mar 26, 2012 3:51 pm (PDT)
Randy,
That works great, thank you.
Jeff
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I didn't see an example below?
>
> You can't have it both ways -- you'd need to choose one or the other.
>
> Hmmm. How about in a comment? Something like:
>
> =RCHCreateComment("",0,500, 50,,,,,RCHGetTab leCell("
> https://schwabweekly.marketedge. com/secop/
> "&J3&".asp?p=SC",0,">Recommen dation"," class=f1l" ),"Recommendatio n")
>
> On Sun, Mar 25, 2012 at 11:19 PM, smithjhhic <smithjhhic@...> wrote:
>
> > Randy,
> > Yes, my error. Related question, I would like to keep my row height 1
> > line vs. auto height. However, I don't know of a method to view the
> > information when focused on a cell with multi-line content (ex below)
> > without expanding the height. Do you know of a method? The formula bar
> > shows only the formula. I am an Excel novice and unable to find the answer
> > in searching help.
> > v/r,
> > Jeff
> >
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar