search

ClimberMel / SMF_Add-in

Stock Market Functions for Excel using VBA
https://climbermel.github.io/SMF_Add-in/
14 stars 5 forks source link

Example workbook which doesn't retrieve quotes for Google Groups discussion #57

Closed whateverusernameisnottaken closed 3 days ago

whateverusernameisnottaken commented 5 months ago

List of Assets-2024-01-19-sanitized.xlsx

ClimberMel commented 5 months ago

Hi Brad, there are no SMF formulas in this sheet. Where did you want to retrieve the quotes to? I also had to change G55 from =SUM(G50:G55) to =SUM(G50:G54) to get rid of the circular reference error. I added in =RCHGetElementNumber(A61, 15) to cell F61 to get the price for a stock in A61 image

ClimberMel commented 5 months ago

Here is your sheet with that changed. List.of.Assets-2024-02-02.xlsx

whateverusernameisnottaken commented 5 months ago

Mel:

Thanks. Should I assume that uses an array function? Because if I just past that formula into A61 I get "not found".

On Fri, Feb 2, 2024 at 6:21 PM ClimberMel @.***> wrote:

Hi Brad, there are no SMF formulas in this sheet. Where did you want to retrieve the quotes to? I also had to change G55 from =SUM(G50:G55) to =SUM(G50:G54) to get rid of the circular reference error. I added in =RCHGetElementNumber(A61, 15) to cell F61 to get the price for a stock in A61 image.png (view on web) https://github.com/ClimberMel/SMF_Add-in/assets/9968993/3a02fa0a-ae46-4a1d-a4bc-8daca4347901

— Reply to this email directly, view it on GitHub https://github.com/ClimberMel/SMF_Add-in/issues/57#issuecomment-1924895739, or unsubscribe https://github.com/notifications/unsubscribe-auth/AFBMBCD5HIEWG5UDNOKCNCDYRVYGJAVCNFSM6AAAAABCVSUPYKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMRUHA4TKNZTHE . You are receiving this because you authored the thread.Message ID: @.***>

-- Brad Karal

ClimberMel commented 5 months ago

The formula should have already been in A61.  You should be able to just open the sheet and it should have the value.No I avoided using an array MelSent from my Galaxy -------- Original message --------From: whateverusernameisnottaken @.> Date: 2024-02-03 6:34 p.m. (GMT-08:00) To: ClimberMel/SMF_Add-in @.> Cc: ClimberMel @.>, Comment @.> Subject: Re: [ClimberMel/SMF_Add-in] Example workbook which doesn't retrieve quotes for Google Groups discussion (Issue #57) Mel:

Thanks. Should I assume that uses an array function? Because if I just

past that formula into A61 I get "not found".

On Fri, Feb 2, 2024 at 6:21 PM ClimberMel @.***> wrote:

Hi Brad, there are no SMF formulas in this sheet. Where did you want to

retrieve the quotes to? I also had to change G55 from =SUM(G50:G55) to

=SUM(G50:G54) to get rid of the circular reference error.

I added in =RCHGetElementNumber(A61, 15) to cell F61 to get the price for

a stock in A61

image.png (view on web)

https://github.com/ClimberMel/SMF_Add-in/assets/9968993/3a02fa0a-ae46-4a1d-a4bc-8daca4347901

—

Reply to this email directly, view it on GitHub

https://github.com/ClimberMel/SMF_Add-in/issues/57#issuecomment-1924895739,

or unsubscribe

https://github.com/notifications/unsubscribe-auth/AFBMBCD5HIEWG5UDNOKCNCDYRVYGJAVCNFSM6AAAAABCVSUPYKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMRUHA4TKNZTHE

.

You are receiving this because you authored the thread.Message ID:

@.***>

--

Brad Karal

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you commented.Message ID: @.***>

whateverusernameisnottaken commented 5 months ago

Mel:

You're right-it was there in A61. And Excel is showing "not found" for the result. What next?

On Sat, Feb 3, 2024 at 9:53 PM ClimberMel @.***> wrote:

The formula should have already been in A61. You should be able to just open the sheet and it should have the value.No I avoided using an array MelSent from my Galaxy -------- Original message --------From: whateverusernameisnottaken @.> Date: 2024-02-03 6:34 p.m. (GMT-08:00) To: ClimberMel/SMF_Add-in @.> Cc: ClimberMel @.>, Comment @.> Subject: Re: [ClimberMel/SMF_Add-in] Example workbook which doesn't retrieve quotes for Google Groups discussion (Issue #57) Mel:

Thanks. Should I assume that uses an array function? Because if I just

past that formula into A61 I get "not found".

On Fri, Feb 2, 2024 at 6:21 PM ClimberMel @.***> wrote:

Hi Brad, there are no SMF formulas in this sheet. Where did you want to

retrieve the quotes to? I also had to change G55 from =SUM(G50:G55) to

=SUM(G50:G54) to get rid of the circular reference error.

I added in =RCHGetElementNumber(A61, 15) to cell F61 to get the price for

a stock in A61

image.png (view on web)

< https://github.com/ClimberMel/SMF_Add-in/assets/9968993/3a02fa0a-ae46-4a1d-a4bc-8daca4347901

—

Reply to this email directly, view it on GitHub

< https://github.com/ClimberMel/SMF_Add-in/issues/57#issuecomment-1924895739 ,

or unsubscribe

< https://github.com/notifications/unsubscribe-auth/AFBMBCD5HIEWG5UDNOKCNCDYRVYGJAVCNFSM6AAAAABCVSUPYKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMRUHA4TKNZTHE

.

You are receiving this because you authored the thread.Message ID:

@.***>

--

Brad Karal

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub https://github.com/ClimberMel/SMF_Add-in/issues/57#issuecomment-1925559847, or unsubscribe https://github.com/notifications/unsubscribe-auth/AFBMBCFBAH2F3PTY754IXBTYR3ZZXAVCNFSM6AAAAABCVSUPYKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMRVGU2TSOBUG4 . You are receiving this because you authored the thread.Message ID: @.***>

-- Brad Karal

ClimberMel commented 5 months ago

I'll see what I can come up with to test where the disconnect is...Sent from my Galaxy -------- Original message --------From: whateverusernameisnottaken @.> Date: 2024-02-03 6:57 p.m. (GMT-08:00) To: ClimberMel/SMF_Add-in @.> Cc: ClimberMel @.>, Comment @.> Subject: Re: [ClimberMel/SMF_Add-in] Example workbook which doesn't retrieve quotes for Google Groups discussion (Issue #57) Mel:

You're right-it was there in A61. And Excel is showing "not found" for the

result.

What next?

On Sat, Feb 3, 2024 at 9:53 PM ClimberMel @.***> wrote:

The formula should have already been in A61. You should be able to just

open the sheet and it should have the value.No I avoided using an

array MelSent from my Galaxy

-------- Original message --------From: whateverusernameisnottaken

@.***> Date: 2024-02-03 6:34 p.m. (GMT-08:00) To:

ClimberMel/SMF_Add-in @.> Cc: ClimberMel @.>, Comment

@.***> Subject: Re: [ClimberMel/SMF_Add-in] Example workbook which

doesn't retrieve quotes for Google Groups discussion (Issue #57)

Mel:

Thanks. Should I assume that uses an array function? Because if I just

past that formula into A61 I get "not found".

On Fri, Feb 2, 2024 at 6:21 PM ClimberMel @.***> wrote:

Hi Brad, there are no SMF formulas in this sheet. Where did you want to

retrieve the quotes to? I also had to change G55 from =SUM(G50:G55) to

=SUM(G50:G54) to get rid of the circular reference error.

I added in =RCHGetElementNumber(A61, 15) to cell F61 to get the price for

a stock in A61

image.png (view on web)

<

https://github.com/ClimberMel/SMF_Add-in/assets/9968993/3a02fa0a-ae46-4a1d-a4bc-8daca4347901

—

Reply to this email directly, view it on GitHub

<

https://github.com/ClimberMel/SMF_Add-in/issues/57#issuecomment-1924895739

,

or unsubscribe

<

https://github.com/notifications/unsubscribe-auth/AFBMBCD5HIEWG5UDNOKCNCDYRVYGJAVCNFSM6AAAAABCVSUPYKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMRUHA4TKNZTHE

.

You are receiving this because you authored the thread.Message ID:

@.***>

--

Brad Karal

—Reply to this email directly, view it on GitHub, or unsubscribe.You are

receiving this because you commented.Message ID: @.***>

—

Reply to this email directly, view it on GitHub

https://github.com/ClimberMel/SMF_Add-in/issues/57#issuecomment-1925559847,

or unsubscribe

https://github.com/notifications/unsubscribe-auth/AFBMBCFBAH2F3PTY754IXBTYR3ZZXAVCNFSM6AAAAABCVSUPYKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMRVGU2TSOBUG4

.

You are receiving this because you authored the thread.Message ID:

@.***>

--

Brad Karal

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you commented.Message ID: @.***>