4 Messages
Digest #3006
Messages
Sat Mar 15, 2014 4:26 am (PDT) . Posted by:
rajarjrtj
Thanks for the suggestions.
To clarify, is your work around that I copy and paste as values the updated cells in the same location, or is it a different method that preserves the formulae?
Perhaps I could create a new workbook solely for the historic Quotes, open and recalculate to update, then save and close. Then open the API workbook that has the required cells linked to the Quotes workbook so the values will remain static. I believe this should be a decent work around.
To clarify, is your work around that I copy and paste as values the updated cells in the same location, or is it a different method that preserves the formulae?
Perhaps I could create a new workbook solely for the historic Quotes, open and recalculate to update, then save and close. Then open the API workbook that has the required cells linked to the Quotes workbook so the values will remain static. I believe this should be a decent work around.
Sat Mar 15, 2014 4:42 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Copy and paste as values would be one option. Your method would be another.
Another option would be to use VBA code similar to this:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/708
Then, you just run that macro when you want to update the historical quotes.
A lot of ways to go...
On Sat, Mar 15, 2014 at 4:26 AM, <rajarjrtj@yahoo.com> wrote:
>
> To clarify, is your work around that I copy and paste as values the
> updated cells in the same location, or is it a different method that
> preserves the formulae?
>
> Perhaps I could create a new workbook solely for the historic Quotes, open
> and recalculate to update, then save and close. Then open the API workbook
> that has the required cells linked to the Quotes workbook so the values
> will remain static. I believe this should be a decent work around.
>
Another option would be to use VBA code similar to this:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/708
Then, you just run that macro when you want to update the historical quotes.
A lot of ways to go...
On Sat, Mar 15, 2014 at 4:26 AM, <rajarjrtj@yahoo.com> wrote:
>
> To clarify, is your work around that I copy and paste as values the
> updated cells in the same location, or is it a different method that
> preserves the formulae?
>
> Perhaps I could create a new workbook solely for the historic Quotes, open
> and recalculate to update, then save and close. Then open the API workbook
> that has the required cells linked to the Quotes workbook so the values
> will remain static. I believe this should be a decent work around.
>
Sat Mar 15, 2014 5:06 am (PDT) . Posted by:
rajarjrtj
Great, your VBA code solution should serve well. It looks as though the quote grab routine is run only manually, and I can add a "button" to initiate.
Is this correct?
Is this correct?
Sat Mar 15, 2014 8:40 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That is correct.
On Sat, Mar 15, 2014 at 5:06 AM, <rajarjrtj@yahoo.com> wrote:
>
> Great, your VBA code solution should serve well. It looks as though the
> quote grab routine is run only manually, and I can add a "button" to
> initiate.
>
> Is this correct?
>
On Sat, Mar 15, 2014 at 5:06 AM, <rajarjrtj@yahoo.com> wrote:
>
> Great, your VBA code solution should serve well. It looks as though the
> quote grab routine is run only manually, and I can add a "button" to
> initiate.
>
> Is this correct?
>
Tidak ada komentar:
Posting Komentar