Messages
Mon Dec 9, 2019 1:27 pm (PST) . Posted by:
Randy, I regularly use the smfForceRecalculation macro in
Yahooportfolioview during the day to update my data. I have recorded
another macro that will sort the data after it is refreshed. I would like
to make this a one -click event, but the Force Recalculation macro is
within the addin and therefore not readily available, as is also stated in
the FAQ.
I have googled and tried every possible solution that is not too far beyond
my limited VBA skills, but to no avail. Is there a way to have the Force
Recalculation macro act as a regular macro that one could use together with
other macros?
And on another note, does it matter how many field numbers I use in the
Yahooportfolioview? In other words; if I only call last price, is it more
"lightweight" than when I also call open, high and low?
Thanks, Marco
Mon Dec 9, 2019 1:40 pm (PST) . Posted by:
On Mon, Dec 9, 2019 at 2:28 PM Marco Deen marco.deen@... wrote:
>
> Randy, I regularly use the smfForceRecalculation macro in
> Yahooportfolioview during the day to update my data. I have recorded
> another macro that will sort the data after it is refreshed. I would like
> to make this a one -click event, but the Force Recalculation macro is
> within the addin and therefore not readily available, as is also stated in
> the FAQ.
> I have googled and tried every possible solution that is not too far
> beyond my limited VBA skills, but to no avail. Is there a way to have the
> Force Recalculation macro act as a regular macro that one could use
> together with other macros?
>
In the VBA project for your other macro, use menu option > Tools >
References and check the box in front of the "RCH_Stock_Market_Functions"
reference library. That will make everything from the add-in available to
your VBA project.
And on another note, does it matter how many field numbers I use in the
> Yahooportfolioview? In other words; if I only call last price, is it more
> "lightweight" than when I also call open, high and low?
>
I would expect the difference to be very, very small. Measurable, but not
physically noticeable.
Mon Dec 9, 2019 2:09 pm (PST) . Posted by:
Thanks Randy. So I have opened my "Resortmacro" macro and ticked the box
under tools.
Sub ResortMacro()
'
' ResortMacro Macro
'
'
Columns("A:H").Select
ActiveWorkbook.Worksheets("B").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("B").Sort.SortFields.Add
Key:=Range("F2:F518"), _
SortOn:=xlSortOnValues, Order:=xlDescending,
DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("B").Sort
.SetRange Range("A1:H518")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Range("A1").Select
End Sub
Now if I put "Call smfForceRecalculation" above the line "
Columns("A:H").Select", would that do the trick?
On Mon, Dec 9, 2019 at 4:41 PM Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> On Mon, Dec 9, 2019 at 2:28 PM Marco Deen marco..deen@... wrote:
>
>>
>> Randy, I regularly use the smfForceRecalculation macro in
>> Yahooportfolioview during the day to update my data. I have recorded
>> another macro that will sort the data after it is refreshed. I would like
>> to make this a one -click event, but the Force Recalculation macro is
>> within the addin and therefore not readily available, as is also stated in
>> the FAQ.
>> I have googled and tried every possible solution that is not too far
>> beyond my limited VBA skills, but to no avail. Is there a way to have the
>> Force Recalculation macro act as a regular macro that one could use
>> together with other macros?
>>
>
> In the VBA project for your other macro, use menu option > Tools >
> References and check the box in front of the "RCH_Stock_Market_Functions"
> reference library. That will make everything from the add-in available to
> your VBA project.
>
>
>
> And on another note, does it matter how many field numbers I use in the
>> Yahooportfolioview? In other words; if I only call last price, is it more
>> "lightweight" than when I also call open, high and low?
>>
>
> I would expect the difference to be very, very small.. Measurable, but not
> physically noticeable.
>
>
>
Mon Dec 9, 2019 3:14 pm (PST) . Posted by:
The macro should work, but if range A1:H518 range contains an array-entered
smfGetYahooPortfolioView() function, you're not going to be able to sort
the data.
On Mon, Dec 9, 2019 at 3:09 PM Marco Deen marco.deen@.... wrote:
>
>
> Thanks Randy. So I have opened my "Resortmacro" macro and ticked the box
> under tools.
>
> Sub ResortMacro()
> '
> ' ResortMacro Macro
> '
>
> '
> Columns("A:H").Select
> ActiveWorkbook.Worksheets("B").Sort.SortFields.Clear
> ActiveWorkbook..Worksheets("B").Sort.SortFields.Add
> Key:=Range("F2:F518"), _
> SortOn:=xlSortOnValues, Order:=xlDescending,
> DataOption:=xlSortNormal
> With ActiveWorkbook.Worksheets("B").Sort
> .SetRange Range("A1:H518")
> .Header = xlYes
> .MatchCase = False
> .Orientation = xlTopToBottom
> .SortMethod = xlPinYin
> .Apply
> End With
> Range("A1").Select
> End Sub
>
> Now if I put "Call smfForceRecalculation" above the line "
> Columns("A:H").Select", would that do the trick?
>
>
