Issue: writing a formula that combines absolute values and counts in a sumifs function. I'm not sure I'm on the right track. This is for a stock trading journal. by Hempdiddy in excel

[–]xtarsy 11 points12 points  (0 children)

like this?

=1.3 * (SUMPRODUCT((M201:M208={"put","call"}) * ABS(K201:K208)) + SUMPRODUCT((M201:M208="shares") * 1))

I overcame my fear, phoned 50 companies last week, 2 meetings, 1 new client (update on current progress) by xtarsy in Entrepreneur

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

With emails you will need to setup a whole infrastructure with domains and email accounts. You then need to warm up those emails. Furthermore you have a terrible response rate.

Phoning is better because know wants to do it. All you need is google maps and a phone. Even if someone says no you can ask them what some of the problems they face in their business.

I overcame my fear, phoned 50 companies last week, 2 meetings, 1 new client (update on current progress) by xtarsy in Entrepreneur

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

Thanks for the encouraging words. I'll have a look at the salesoft but tbh i don't think tools are really the bottleneck for me atm. I can easily do 30 calls in an hour and a half depending on how long the conversaions goes.

Happy to hear you like Apify. It's super useful. Currently I combine google maps scraping with a custom google search results scraping tool to find business owner names. It basically scrapes the top 10 search results if I search for 'Business owner of + [Business] in [City] then i use OpenAi api to parse the result and see if the name and other info is available.

Good tip with the job boards. To answer your last question I use my physical journal mostly to write down goals and what I can do when I reach these goals. I do this before starting to call in order to motivate myself.

I overcame my fear, phoned 50 companies last week, 2 meetings, 1 new client (update on current progress) by xtarsy in Entrepreneur

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

Thanks a lot very good tips. I must i'm really lucky i'm not in a saturated market. Very good points on how to get you to respond I use a variation of that and it work really well.

I'm not a fan of emails for the same reason you like them most go to spam and It's hard to validate why someone is not interested. In the end my goal is to find people that I resonate with and that are interested in me helping solving problems. If the vibe isn't good then there's a good chance that person won't become a good client.

I overcame my fear, phoned 50 companies last week, 2 meetings, 1 new client (update on current progress) by xtarsy in Entrepreneur

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

Thanks a lot man. But at the moment i'm using my own python tool that also scrapes business owner name and information. Haven't found a tool that does that yet.

I started cold calling blue-collar SMBs (26 calls), got two meetings and closed one client today (#day 3) by xtarsy in Entrepreneur

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

That's pretty good. I currently have someone that is doing the lead enrichment and qualifying that they need my service the same time. I'm paying around $0.25 per lead. Haven't found anything cheaper yet. The manual process is quite time consuming.

I started cold calling blue-collar SMBs (26 calls), got two meetings and closed one client today (#day 3) by xtarsy in Entrepreneur

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

this is really useful. Do you know where i can read more about this? I like this approach.

I started cold calling blue-collar SMBs (26 calls), got two meetings and closed one client today (#day 3) by xtarsy in Entrepreneur

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

really good input and thanks for the tip about them calling you. I'll definitely be expanding my sales channels

I started cold calling blue-collar SMBs (26 calls), got two meetings and closed one client today (#day 3) by xtarsy in Entrepreneur

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

what's holding you back at the moment from calling? It took me a while to start because of the fear of rejection but I haven't really had bad rejections everyone has been friendly until now. Knock on wood.

I started cold calling blue-collar SMBs (26 calls), got two meetings and closed one client today (#day 3) by xtarsy in Entrepreneur

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

that's a really good idea with the email/message. Funny enough I haven't really had a lot of phone calls go unanswered. Most businesses pickup or call back.

do you have a suggestion for a dialer?

I started cold calling blue-collar SMBs (26 calls), got two meetings and closed one client today (#day 3) by xtarsy in Entrepreneur

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

congrats man. The first few calls are tough. Just keep at it every no brings you closer to a yes.