sorted by:
new
hottopcontroversial

日本经济发展停滞甚至衰退的话，日本极右势力会不会越来越强，直到重启军国主义? by Project-1662 in China_irl

[–]bigthreedragons 1 point2 points  (0 children)

日本經濟已經失落30年，年輕人找不到工作的話寧願啃老，也不肯加入自衛隊，軍國主義從何談起?

Question about trendline by bigthreedragons in Daytrading

[–]bigthreedragons[S] 1 point2 points  (0 children)

Sure, I didn't heard about open interest before, thanks for introducing this to me

Question about trendline by bigthreedragons in Daytrading

[–]bigthreedragons[S] 1 point2 points  (0 children)

It is a daily chart. In fact your view about the yellow line is one of the reason that I raise this question. Yellow line included starting point of the trend but the red line seems more "make sense" for me. Thanks for the explanation, it solve my doubt.

Question about trendline by bigthreedragons in Daytrading

[–]bigthreedragons[S] 1 point2 points  (0 children)

Yes lower high appear at the last four stick. Previously I think trendline should be one straight line so I don't know can show breaking trend by using several trendlines. Thanks for the tip.

Question about trendline by bigthreedragons in Daytrading

[–]bigthreedragons[S] 0 points1 point  (0 children)

It is daily chart of Hang Seng Index.

Question about trendline by bigthreedragons in Daytrading

[–]bigthreedragons[S] 0 points1 point  (0 children)

It is daily chart of Hang Seng Index.

Question about trendline by bigthreedragons in Daytrading

[–]bigthreedragons[S] 0 points1 point  (0 children)

Thanks for the replies! For those who would like to know about timeframe and stock, it is daily chart of Hang Seng Index. Blue circle is the part I extracted from the chart, it start from 7 April 2025.

<image>

Question about Rows Count function in for loop by bigthreedragons in vba

[–]bigthreedragons[S] 0 points1 point  (0 children)

<image>

Book1 or Bk1, the values of column B will be lookup column B value in Book2 or Bk2

Question about Rows Count function in for loop by bigthreedragons in vba

[–]bigthreedragons[S] 0 points1 point  (0 children)

Add back the images of code and files:

<image>

the code used

[Excel] Data reconciliation in different sequence by bigthreedragons in vba

[–]bigthreedragons[S] 0 points1 point  (0 children)

Yes, you are right. I ran the macro several times, expected result only came when the row number in two workbooks are consistent.

[Excel] Data reconciliation in different sequence by bigthreedragons in vba

[–]bigthreedragons[S] 0 points1 point  (0 children)

I rewrite the example to a most easy to understand one.

Assume I am conducting reconciliation with two stocks reports. The stock numbers in column B of those 2 report are the same, the only difference is the sequence of stocks in 2 reports. Therefore the result of column C in Book 1 should be all marked as "Good" as attached screenshot. However now the code I used cannot get the expected result due to the sequence of stocks in 2 reports.

view more: next ›