u/mshparber

I am building an SQL query that calculates the balances per each Bank Account in that ACCOUNT CURRENCY.

I do see transactions where the transaction currency is different from the account currency.
My question is - what is the meaning of the foreignamount field in the transactionline table in such cases? For example, one of the accounts is in USD, but one of the transaction currencies is GBP, so if I see 20000 in foreignamount - is it in GBP or USD
Can someone clarify please?
Thank you

SELECT a.id AS account_id, a.acctNumber AS account_number, a.fullname AS account_name, BUILTIN.DF(a.currency) AS account_currency, SUM(tl.foreignamount) AS balance_account_ccy, SUM(tal.amount) AS balance_base_ccy FROM TransactionAccountingLine tal JOIN TransactionLine tl ON tal.transaction = tl.transaction AND tal.transactionline = tl.id JOIN Account a ON tal.account = a.id JOIN Transaction t ON tal.transaction = t.id WHERE a.accttype = 'Bank' AND tal.posting = 'T' AND tal.accountingbook = 1 -- Primary Book - verify ID AND t.trandate <= TO_DATE('2024-12-31', 'YYYY-MM-DD') -- as-of cutoff GROUP BY a.id, a.acctNumber, a.fullname, a.currency ORDER BY a.acctNumber

I am a newbie, bought a brand new crf300L a week ago and exploring it. I tried twice to ride on wide flat trails where I noticed as soon as I stand up, my arms straighten and pull the throttle. I am rather heavy (243 lbs/ 110 kg) and tall (186 cm/ 6’1”) What tips can you give for standing when riding on trails? Thanks

I am a newbie, bought a brand new crf300l a week ago and exploring it. I tried twice to ride on wide trails where I want to stand up but I noticed as soon as I stand up, my arms straighten and pull the throttle. I am rather heavy (243 lbs/ 110 kg) and tall (186 cm/ 6’1”) What tips can you give for riding crf300l on trails Thanks

Hello friends,
My AMD has run up a lot and i would like to hedge similar to "zero-cost collar" McMillan strategy, but with some variations.
My main goal is to protect my profits while allowing a stock to rise.
I prefer not to sell stocks so I delay taxes. I am also not looking to sell options for income.
I am bulling for AMD for the long run, but want to protect profits against pullbacks.
Here are some strategies I am considering:

1. AMD Jun 18th 330/410 Collar (zero cost) - I allow for pullback to 330 but 410 upside cap feels too low. the close expiration does not allow to set Call strike higher, if I am looking for zero cost

https://optionstrat.com/5vr8dbP4DYzT

2. AMD Dec 18th 330/440 Collar - later expiration allows 440 Call (zero cost)

https://optionstrat.com/csRLXEfpfo1Q

3. AMD Dec 18th long 330Put short 550Call short 260Put (zero cost) - same as previous collar, but I sell 260 Put to move the Call higher to 550. (the image is of this strategy)

https://optionstrat.com/8uhTo7UxKUSH

I would like to hear your thoughts and also:

1. How do I manage this position (say, second 330/440 collar ) if AMD:
   1.1 drops to 280?
   1.2 runs to 480?
   How would I roll the options if i prefer not to sell?
2. How do I compare each strategy - is there a composite metric I can use? like %upside cap vs risk?
3. The earnings are in two days I understand there will be IV crash right after... so how can I adjust?

Any other thoughts?
Thanks a lot!

https://preview.redd.it/luite4hsvxyg1.png?width=1178&format=png&auto=webp&s=b31e293aa93218fe733d270532d65d671a6ae71a

I hold $MU position than ran up pretty nice during last year. I want to hedge.

By the McMillan book I am considering two alternatives:

I sell ITM $480 Calls for $135 with Time Value of $105 (MU is $510)

If the stock runs higher I will be assigned (if I don’t roll), so my ceiling is $615, and it gives me some soft cushion to the downside.

The second strategy - zero cost collar:

I buy $480 Put and sell $610 Call for total of zero dollars . Here my cap is similar $610, and downside is hard.

the hedge expiration in both scenarios is Dec 2026.

What are your thoughts? Any other ideas?

I hold $MU position than ran up pretty nice during last year. I want to hedge.

By the McMillan book I am considering two alternatives:

I sell ITM $480 Calls for $135 with Time Value of $105 (MU is $510)

If the stock runs higher I will be assigned (if I don’t roll), so my ceiling is $615, and it gives me some soft cushion to the downside.

The second strategy - zero cost collar:

I buy $480 Put and sell $610 Call for total of zero dollars . Here my cap is similar $610, and downside is hard.

the hedge expiration in both scenarios is Dec 2026.

What are your thoughts? Any other ideas?

I hold $MU position than ran up pretty nice during last year. I want to hedge.

By the McMillan book I am considering two alternatives:

I sell ITM $480 Calls for $135 with Time Value of $105 (MU is $510)

If the stock runs higher I will be assigned (if I don’t roll), so my ceiling is $615, and it gives me some soft cushion to the downside.

The second strategy - zero cost collar:

I buy $480 Put and sell $610 Call for total of zero dollars . Here my cap is similar $610, and downside is hard.

the hedge expiration in both scenarios is Dec 2026.

What are your thoughts? Any other ideas?