Finance 3.0 - Social Network for Finance
Smart financial thinking
-
Hemal P Patel
- Male
- Absecon, NJ
- United States
- Corporate Analyst
- Share
- Share on Twitter
- Share on Facebook
- Blog Posts
- Discussions (15)
- Events
- Groups (3)
- Charts
- Chart Portfolios
- Videos
Hemal P Patel's Groups
-
Bankers
170 members
-
Financial Analysts
573 members
-
Spreadsheet Junkies
432 members
Hemal P Patel's Discussions
benefits of SAS
1 Reply
Started this discussion. Last reply by TL Aug 17.
VANTAGE - IPS SENDERO - ASSET LIABILITY MANAGEMENT
Started Aug 2
Excel help! Combining Bar and Line Graph
2 Replies
Started this discussion. Last reply by Russ Huntley Jul 27.
Hemal P Patel's Page
Gifts Received
Hemal P Patel has not received any gifts yet
Latest Activity
For SAS i think it is stronger at consolidating multiple data-sources, and for really large volume of data, excel+access has quite a computational difficulty.
consultant, Vast Talent
Hello All,
I have an external consulting group coming in to assess our reporting capabilities, systems and procedures in place to manage our current credit portfolio. We had an SAS reseller come in to do a SAS presentation but we were'nt much comfo…
Does anyone have hands on experience with Vantage by IPS Sendero? I recently just started learning the software and was wondering if anyone has any tutorials. Thanks in advance.
Hemal-
Click on a point and right click the mouse and format data series. Go to line and make sure that there is a line. Can also try and see it a trend line will link the data points.
try secondary axis it might solve ur problem
Hello, I have created a combined graph showing a correlation between interest rates and balances. The Bar graph shows up fine but the Line graph only has dots with no lines connected. I've tried all but nothing seems to connect the dots...please hel…
does anyone have any experience using Vantage Asset Liability Management software? or any tutorials they can forward me? Thanks in advance.
Hemal
I agree, the past two years of industry as an whole has been in a turmoil and hence, not a true picture of normal stock behavior. I still feel comforatble atleast 4 and half years of stock data for the peer group banks because of mirroring financial…
Hemal -
From my experience, it is customary to look at industry comps as a proxy for expected volatility. But remember, what you are (most likely) looking for is expected volatility, right? There is a lot of debate as to whether the past is the bes…
And how about using the beta concept?Select the beta of your most closely compared bank.Unlever it to remove the capital structure proportions.Then using the expected capital structure (debt and equity proportions) of your bank,you lever the beta an…
Aaron,
When i am looking at moving averages vs. stock prices, should i look at 30 days, or 60 days, or 90 days, etc...? also, when i take the stdev of past 30 or 60 or 90 days for the entire 6.6 year period, should i then annualize it? I am not sur…
You are seeking a standard deviation number for you stock. I'm not sure that identifying a 66% chance of a stock trading in an 84% window is of much actual or even theoretical use. You might have better results with moving averages vs actual stock p…
The last 2 years have not been good for banks, interest rates are distorted, business models have changed and hence any projections based on limited historical data may not be a good idea. It is better to have a larger population (say Bankex as a wh…
Hello,
Yes, i am using 6.5 years of daily closing price for calculation purpose. Here's what i did. I took natural log of today's closing price over yesterdays closing price for the 6.5 year period. I then took Stdev for all the natural logs and mu…
I agree with the above opinion. You can use a proxy, but you also can compare the last 0.5 year performance of your bank with the peer group's performance and make appropriate adjustments if needed. However you should also make a note about the meth…
Profile Information
- Profession:
- Banker
- Current Role:
- Corporate Analyst
- Past Experience:
- 6+ years in Banking
- Education:
- Bachelors of Science in Finance/Minors in Comp Science
- Current Location:
- New Jersey
- Interested In:
- career opportunities, knowledge and training, job enquires, getting back in touch
Sign in
Badge
Continuing Education
 |
Accounting |
 |
Banking Regulations |
 |
Certification Training |
 |
Commercial Bank Management |
 |
Corporate Finance & Valuation |
 |
Treasury Management |
 |
Credit Risk Management |
 |
Financial Derivatives |
 |
Financial Institution Management |
 |
Financial Markets |
 |
Financial Modeling |
 |
Financial Planning |
 |
Market Risk Management |
 |
Operational Risk Management |
 |
Operations & Compliance |
 |
Quantitative Analysis |
 |
Strategic Financial Management |
Newsletter
Linkedin
RSS
Facebook
Widgets
Twitter© 2010 Created by Finance 3.0.
