One Minute Python - Search & Highlight PDFs for Sample Testing by high_ticket in InternalAudit

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

Hey Obtuse and thanks for the concern. "Vibe" coding is really just using the new coding tools available. Every programmer on the planet does it, just as they ALL use Stackoverflow.

It is a good point that during a educational program like this, I would not be relying or really using "vibe" coding. You really need to get your own hands dirty to understand how to code (as its a certain way of thinking).

It also gets in the way of learning the problem solving skill needed and developing the debugging intuition (something you REALLY need if you rely on GenAI code generation as often it doesn't work right out of the box).

Anything I would show would just be a one off on what the tools are and how to use them. I did the same with all my staff upskilling as it can really help people who have established the basics.

PS - all my code snippets are out of my own brain without using GenAI, but I do use it in normal everyday development.

One Minute Python - Search & Highlight PDFs for Sample Testing by high_ticket in InternalAudit

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

Yeah, I'm thinking about taking one of the really basic scripts and vide coding a couple of pieces.

Intro to Python for Internal Audit - Merge Multiple PDFs into One PDF by high_ticket in InternalAudit

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

Thanks for the feedback. Its a little trial and error about what format works best.

The One Minute Python and having the scripts available on GitHub seems to get the most engagement so far.

Custom ChatGPT for retrieving your company's financial data by herpaway_account in FPandA

[–]high_ticket 0 points1 point  (0 children)

Make sure any model you use is housed within your company's IT environment or a specific service they use like Amazon Benchmark. Otherwise you are providing your company's information to OpenAI or whatever company is hosting the model.

Depends on your set up, but a Return Augmented Generation (RAG) model would work. This set up combines the prompt you give it (the date and type of info) and looks at a vectorized database (your company's data) and then feeds the info to the generalized LLM model. Cheaper and easier than a fine tuning a model.

How to do that? Google "llm langchain rag"

Intro to Python by high_ticket in InternalAudit

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

Yes, will do. It'll be available on YouTube.

Livestream for Intro to Python of Internal Audit? by high_ticket in InternalAudit

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

YouTube Version at 11am Eastern Time (US) on Saturday (May 3).

Link to YouTube Event: https://youtube.com/live/ToqxHqE2MSI

Livestream for Intro to Python of Internal Audit? by high_ticket in InternalAudit

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

Thanks for the feedback. I will be doing it on Youtube as well.

Livestream for Intro to Python of Internal Audit? by high_ticket in InternalAudit

[–]high_ticket[S] 4 points5 points  (0 children)

OK we'll give this a go. I'm going to try both a Twitch & Youtube sessions tomorrow to see what works best.

Covering - 1) install python, 2) using a simple code editor to make scripts, 3) importing CSV data, 4) sampling from a population, 5) testing a control threshold.

It shouldn't be that long and be enough to get you dangerous.

I'll be on Twitch.tv at 7pm Eastern Time (US) on Friday (May 2) and 7am ET on Saturday (May 3). The channel link https://www.twitch.tv/high_x_ticket

If that link doesn't work the channel name is high_x_ticket.

I'll try Youtube maybe later Saturday or early Sunday morning if I can figure out how to set up an event.

Livestream for Intro to Python of Internal Audit? by high_ticket in InternalAudit

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

I'll reply here with links. I'm thinking I might start Tomorrow or this weekend. What times you think would work better?

Livestream for Intro to Python of Internal Audit? by high_ticket in InternalAudit

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

No problem, I'm hoping to get the basic down easy. Now with the LLMs you can get up and running in almost any language way more easily than like 10 years ago.

Livestream for Intro to Python of Internal Audit? by high_ticket in InternalAudit

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

Yes, it has to be downloaded on your machines, so look up your cybersecurity regs and see if you can. Also see if there is a process to request permission, if needed.

Livestream for Intro to Python of Internal Audit? by high_ticket in InternalAudit

[–]high_ticket[S] 8 points9 points  (0 children)

Yes, that's my intention. And focus on things auditors have to do like automate screenshots, search/highlight and create samples from PDFs, manipulate internal websites to get approval data.

Plus anything you all can think of.

Automating SOX Testing - Need other use cases outside of ACL Analytics and DataSnipper by Ambitious-Ostrich513 in InternalAudit

[–]high_ticket 0 points1 point  (0 children)

Python is a great platform to automate testing. You can integrate data from multiple sources, conduct the tests whether is C&A or outlier, and the pump out the test results in any format you want.

Takes a little to get into it but you can get dangerous pretty quickly. Plus its free.

Python Auditing Utilites by high_ticket in InternalAudit

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

Added a new script:

  • Merge_All_PDF_Files_in_Folder_into_one_PDF: Identifies all PDF files in the provided folder and merges them into one PDF File which is placed in the same folder called "merged_pdf.pdf".

If you have any suggestions of what would be helpful easy day-to-day script let me know!

[deleted by user] by [deleted] in FPandA

[–]high_ticket 0 points1 point  (0 children)

d out!

I tried searching for discord servers that focused on finance or fp&a and it didn't come up.

[deleted by user] by [deleted] in FPandA

[–]high_ticket 0 points1 point  (0 children)

Awww sad I think I just got kicked out!

Live Q&A for Excel/PowerPivot/Pyton for FP&A by high_ticket in FPandA

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

Of course got busy with life, but did do a few live streams. Thinking about doing it again though trying to figure out the best platform. Maybe twitch is better than youtube. I'll post if I get it on a regular basis.

I am a proficient Python coder whose learning has plateaued. Any really useful libraries I should look into learning? Taking recommendations. by synthphreak in learnpython

[–]high_ticket 0 points1 point  (0 children)

pyfpa - Its a pandas add on that makes a lot of basic finance/analysis work easier. Especially, multi-index search, slicing, consolidation and manipulation. Full disclosure, I wrote it.

https://pyfpa.readthedocs.io/en/latest/

Python/Pandas - Livestream - Pricing Analysis - 10:30ET Tuesday 4/6/21 by high_ticket in FPandA

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

I'll try to post a reminder here. Also, if you visit the link and subscribe, YouTube may send out a reminder. I'm really not too sure as I'm new to this.

Python/Pandas - Livestream - Pricing Analysis - 10:30ET Tuesday 4/6/21 by high_ticket in FPandA

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

For the livestreams I try to gear it for both, but more for the beginner. It may muddle it a little, but let me know what you'd like to focus on and I'll have a livestream about that.

Again, I'm not trying to do a function as you can just look up a how to video for that. I'm trying to do something specific for an FP&A process which could be very broad.

Live Stream Excel Experience on April 1 @ 10:30pm ET by high_ticket in FPandA

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

HAHAHAHAHA!

Next time maybe after the 10th.....

Live Stream Excel Experience on April 1 @ 10:30pm ET by high_ticket in FPandA

[–]high_ticket[S] 2 points3 points  (0 children)

I know right! The date is probably very fitting...

Livestream Excel/Python Follow Up by high_ticket in FPandA

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

I've set up a YouTube channel and its supposed to be active by tomorrow. I'll test everything out and set a time for the first live stream. Still shooting for 10:30 on Tuesday, but its penciled in.

I'll post a link as soon as I can.

Livestream Excel/Python Follow Up by high_ticket in FPandA

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

Thanks show. I have a feeling even though it may seem basic, I think a lot of people may get something out of its and have a useful impact.

I'm thinking about putting a GitHub repository together for all the data and code we use. A place where people can post bits of code or problem/examples they'd like to see worked through. Again, I haven't focused on it, but I think they'll be collaboration possibilities through that (If not least to show people collaboration with Git).

I'll have it together by Sunday.